Contents
see List작성일 2016. 06. 02.
기존
SELECT * FROM (
SELECT A.*,
ROWNUM AS RNUM,
COUNT(*) OVER() AS TOTCNT FROM (
쿼리, 조건,정렬
) A
) WHERE RNUM > '부터' AND RNUM <= '까지'
SELECT
SELECT * FROM (
SELECT A.*,
ROWNUM AS RNUM,
COUNT(*) OVER() AS TOTCNT FROM (
쿼리, 조건,정렬
) A
) WHERE RNUM > '부터' AND RNUM <= '까지'
SELECT
*
FROM (
SELECT
SELECT
ROWNUM AS RNUM
, A.*
FROM (
쿼리, 조건,정렬
) A
쿼리, 조건,정렬
) A
WHERE
ROWNUM <= '까지'
)
)
WHERE
RNUM > '부터'
database
| No | 작성일 | Title |
|---|---|---|
| 46 | 2014. 09. 30. | [ Database ] 다중 db 의 transaction 관리. |
| 35 | 2014. 09. 25. | [ oracle ] 오라클 XaDataSource 사용중 oracle.jdbc.xa.OracleXAResource.recover 대처법 |