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

[Perry Smith <pedz@xxxxxxxxxxxxxxxx>]

On Aug 15, 2022, at 08:55, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

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.

I see others are commenting after David’s update so:

Thank you David.

This seems to work for me:

SELECT count(*) OVER (), id, basename, sha1 FROM dateien WHERE (lower(ext) in ( 'pxd' ) and ftype = 'file') ORDER BY sha1;

This has, e.g. 73, in the first column for all of the rows.

Attachment: signature.asc
Description: Message signed with OpenPGP