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

[David G. Johnston]

On Monday, August 15, 2022, Perry Smith <p...@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.