SMALL

SELECT A,
       TOTAL_CNT,
       CASE WHEN R_CNT > TOTAL_CNT THEN TOTAL_CNT ELSE R_CNT END READ_CNT
  FROM (SELECT A,
               ROWNUM AS RNUM,
               COUNT (*) OVER () AS TOTAL_CNT,
               (#PAGE_NO# * #PAGE_SIZE#) AS R_CNT
          FROM TEST_TABLE)
WHERE RNUM BETWEEN ( (#PAGE_NO# - 1) * #PAGE_SIZE#) + 1
                AND #PAGE_NO# * #PAGE_SIZE#

LIST

+ Recent posts