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