[SQL] NTILE( )

부서별 연봉별로 그룹을 5개 만들어줘

 

SELECT first_name, email, salary, department,
    NTILE(5) OVER(PARTITION BY department ORDER BY salary DESC)
FROM employees