Re: Can I get the number of results plus the results with a single query?

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: Can I get the number of results plus the results with a single query?
Дата	15 августа 2022 г. 16:55:17
Msg-id	CAKFQuwYR-kmTsRJDQ-2US_KR1jvjORceUMsO5jv9duZBrtZqwg@mail.gmail.com обсуждение исходный текст
Ответ на	Can I get the number of results plus the results with a single query? (Perry Smith <pedz@easesoftware.com>)
Ответы	Re: *SPAM* Re: Can I get the number of results plus the results with a single query? (Perry Smith <pedz@easesoftware.com>)
Список	pgsql-general

On Monday, August 15, 2022, Perry Smith <pedz@easesoftware.com> wrote:

I’ve been toying with row_number() and then sort by row_number descending and pick off the first row as the total number.

Use count as a window function.

David J.

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

От: Perry Smith
Дата: 15 августа 2022 г., 16:49:33
Сообщение: Can I get the number of results plus the results with a single query?

От: jian he
Дата: 15 августа 2022 г., 18:52:52
Сообщение: lateral join with union all