카테고리 없음

쿼리문

Stater 2025. 1. 14. 07:58
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;
반응형