Get total count of rows in pagination query
A typical pagination query with the total number of rows would be:
SELECT * FROM (SELECT outr.*, ROWNUM row_num FROM (SELECT emp_no, emp_name, dob, count(*) over () total_nb FROM emp ORDER BY ...) outr WHERE ROWNUM < ((pagenum * row_size) + 1)) WHERE row_num >= (((pagenum - 1) * row_size) + 1)
Don't forget the ORDER BY
.