https://leetcode.com/problems/department-top-three-salaries/ 습득한 점: 윈도우 함수를 활용할 때, DENSE_RANK() OVER (PARTITION BY departmentid ORDER BY salary DESC) 처럼 PARTITION BY와 ORDER BY를 함께 쓸 수 있다는 점을 알게되었음. + 순위 정하기 함수의 차이점 - ROW_NUMBER(), RANK(), DENSE_RANK() SELECT val , ROW_NUMBER() OVER (ORDER BY val) AS row_number , RANK() OVER (ORDER BY val) AS rank , DENSE_RANK() OVER (ORDER BY val) AS dense_rank ..