GreatB
2013. 2. 22. 17:19
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