Oracle์์ ROW_NUMBER() ์ฌ์ฉ๋ฒ1. ๊ธฐ๋ณธ ์ฌ์ฉ๋ฒ์ ์ฒด ๋ฐ์ดํฐ๋ฅผ ๊ธฐ์ค์ผ๋ก ํ ๋ฒํธ๋ฅผ ๋งค๊ธฐ๋ ์์ ์ ๋๋ค.SELECT EMPLOYEE_ID, NAME, SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS RNFROM EMPLOYEES;๊ฒฐ๊ณผ ์์:EMPLOYEE_IDNAMESALARY RN101Alice90001102Bob85002103Charlie80003 2. ๊ทธ๋ฃน๋ณ๋ก ๋ฒํธ ๋งค๊ธฐ๊ธฐ (PARTITION BY)๋ถ์๋ณ๋ก ๋ฒํธ๋ฅผ ๋งค๊น๋๋ค.SELECT DEPARTMENT_ID, EMPLOYEE_ID, NAME, SALARY, ROW_NUMBER() OVER ( PARTITION BY DEP..