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.
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.
