목록전체 글 (66)

웅겹살의 프로그래밍 삼매경

[SQL] LeetCode SQL 178. Rank Scores (DENSE_RANK)

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;
SQL/SQL 문제풀이 2021. 12. 19. 22:35
[SQL] LeetCode SQL 184. Department Highest Salary

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가 가장높은 친구들 뽑기
SQL/SQL 문제풀이 2021. 12. 1. 14:25
[SQL] LeetCode SQL 177. Nth Highest Salary

https://leetcode.com/problems/nth-highest-salary/ Nth 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 함수(Function) 문제가 나타났다 Mysql Oracle
SQL/SQL 문제풀이 2021. 11. 30. 23:57
[SQL] LeetCode SQL 176. Second Highest Salary

https://leetcode.com/problems/second-highest-salary/ Second 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가 2번째로 높은친구 뽑기 예외조건은 row가 1개일경우 null 출력 MYSQL Oracle
SQL/SQL 문제풀이 2021. 11. 29. 22:02
Prev 1 2 3 4 ··· 17 Next