SELECT *
FROM (
SELECT ROWNUM AS RN, EMPLOYEE_ID, EMPLOYEE_NAME
FROM (
SELECT DISTINCT EMPLOYEE_ID, EMPLOYEE_NAME
FROM EMPLOYEES
ORDER BY EMPLOYEE_ID
)
WHERE ROWNUM <= 2000
)
WHERE RN > 1000;
반응형
SELECT *
FROM (
SELECT ROWNUM AS RN, EMPLOYEE_ID, EMPLOYEE_NAME
FROM (
SELECT DISTINCT EMPLOYEE_ID, EMPLOYEE_NAME
FROM EMPLOYEES
ORDER BY EMPLOYEE_ID
)
WHERE ROWNUM <= 2000
)
WHERE RN > 1000;