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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

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