찌니의 프로그래밍 삼매경

https://leetcode.com/problems/rank-scores/ Rank Scores - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com -- MYSQL SELECT score , DENSE_RANK() OVER (ORDER BY score DESC ) 'rank' FROM Scores; -- ORACLE SELECT score , DENSE_RANK() OVER (ORDER BY score DESC ) as rank FROM Scores;

https://leetcode.com/problems/department-highest-salary/ Department Highest Salary - LeetCode Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 부서별 salary가 가장높은 친구들 뽑기