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
'프로그래밍' 카테고리의 다른 글
형식 이니셜라이저에서 예외를 throw했습니다 (0) | 2013.04.26 |
---|---|
0x8007007E (0) | 2013.04.18 |
miplatform- 한 행(줄)의 합계 (0) | 2012.11.02 |
miplatform rowtype 변경 (0) | 2012.11.02 |
java.lang.NoClassDefFoundError: org/apache/commons/lang/time/FastDateFormat (0) | 2012.10.31 |