How can I bring the recordset count inside the same recordset?
539442Dec 29 2006 — edited Dec 29 2006I have a query inside a procedure where I'm paging the results.
I dont know how to bring the total results inside the recordset.
How can I bring the recordset count inside the same recordset?
SELECT *
FROM ( select a.*, rownum rnum
FROM (SELECT
*
FROM table
ORDER BY id DESC) a
WHERE rownum <= pg*50 )
WHERE rnum > (pg-1)*50