Re: Can any_value be used like first_value in an aggregate? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Can any_value be used like first_value in an aggregate?
Date
Msg-id 3998e51e47ce6b00c690cabfe4c60004ba42d8eb.camel@cybertec.at
Whole thread Raw
In response to Re: Can any_value be used like first_value in an aggregate?  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Can any_value be used like first_value in an aggregate?
List pgsql-general
On Tue, 2024-06-25 at 14:11 -0500, Bruno Wolff III wrote:
> The actual
> use case is a set of tripplets returned from a query, where I want on
> row for each distinct value in the first column, paired with the value
> in the second column, for which the third column is the largest. The
> second and third columns are effectively dependent on each other, so there
> won't be any ambiguity.

Try

  SELECT DISTINCT ON (first_column)
         first_column,
         second_column,
         third_column
  FROM the_table
  ORDER BY first_column, third_column DESC;

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: "Shenavai, Manuel"
Date:
Subject: RE: Autovacuum, dead tuples and bloat
Next
From: Dominique Devienne
Date:
Subject: current_role of caller of a DEFINER function