News for hackers. Stuff that matters.
Re:PRQL, Pipelined Relational Query Language by tgulacsi on Wednesday July 26, 2023 @01:27AM (#36873467)
This is the "set based" approach for the MAX: there does not exist a bigger element:

  SELECT article, dealer, price
    FROM   shop s1
    WHERE  NOT EXISTS (SELECT 1 FROM shop s2 
                         WHERE s2.price > s1.price AND
                               s2.article = s2.article)
    ORDER BY article;

There are no comments on this comment yet.