Re: Can any_value be used like first_value in an aggregate?

On Wed, Jun 26, 2024 at 09:50:59 +0200,
Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>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;

That approach worked for that part of the query. Thanks.