> On Aug 15, 2022, at 08:55, David G. Johnston <david.g.johns...@gmail.com> > wrote: > > On Monday, August 15, 2022, Perry Smith <p...@easesoftware.com > <mailto: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.
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.
signature.asc
Description: Message signed with OpenPGP
