Re: Functionally dependent columns in SELECT DISTINCT

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Functionally dependent columns in SELECT DISTINCT
Дата
Msg-id CAKFQuwYrn=Z2Yk4CJ_FGBrsu4ubvcqK101VmzviyfY0chy+=SQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Functionally dependent columns in SELECT DISTINCT  (Willow Chargin <postgresql@wchargin.com>)
Список 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.

В списке pgsql-general по дате отправления: