Perry Smith schreef op ma 15-08-2022 om 08:49 [-0500]:
> I like to have what I call “baby sitting” messages such as “Completed
> 15 out of 1023”. To do this, I need the number of results a query
> returns but I also need the results.
>
> Currently I’m doing this with two queries such as:
>
> SELECT COUNT(*) FROM table WHERE …. expression …
> SELECT * FROM table WHERE …. expression …
>
> But this requires two queries. Is there a way to do the same thing
> with just one query somehow?
>
> I’ve been toying with row_number() and then sort by row_number
> descending and pick off the first row as the total number.
if i understand your question:
count(*) over ()
(u can use aggregate functions as well, not only window functions)
mvg,
Wim