카테고리 없음
체크쿼리
Stater
2025. 1. 14. 07:07
SELECT *
FROM (
SELECT ROWNUM AS RN, EMPLOYEE_ID, EMPLOYEE_NAME
FROM (
SELECT EMPLOYEE_ID, EMPLOYEE_NAME
FROM EMPLOYEES
ORDER BY EMPLOYEE_ID
)
WHERE ROWNUM <= 2000
)
WHERE RN > 1000;
반응형