Horton
Menu

Re: Functionally dependent columns in SELECT DISTINCT

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Willow Chargin <postgresql@wchargin.com>
Cc: shammat@gmx.net, pgsql-general@lists.postgresql.org
Date: 2024-09-13T17:46:10Z
Lists: pgsql-general 
>
>
>
> > or use a lateral subquery to surgically (fetch first 1) retrieve the
> first row when sorted by recency descending.
>
> I'm not sure that I see how to apply this when I need top-k, not top-1.
>

Fetch first k

It's just a modern limit clause.

David J.