Skill/DB
QUERY Paging
진열사랑
2022. 9. 6. 10:17
SELECT X.*
FROM (
SELECT T.*
, ROW_NUMBER() OVER(ORDER BY T.TDT DESC,T.TRNS_TM DESC) AS RNUM
FROM (SELECT A.*
FROM EMP A
WHERE A.DEPT = '002') T
WHERE TDT BETWEEN :SDT AND : EDT
ORDER BY TDT DESC,TRNS_TM DESC
) X
WHERE X.RNUM BETWEEN :SNO AND :ENO