카테고리 없음

체크쿼리

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;
반응형