I like to have what I call “baby sitting” messages such as “Completed 15 out of 1023”. To do this, I need the number
ofresults 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. The problem is that mucks with the order of the original query because of the sort on row_number. I’ve even
thoughtabout reversing the order and then reversing the order a second time but that seems to be getting more than a
littleabsurd.
Thank you for your time,
Perry