Im between cherry

185. Department Top Three Salaries https://leetcode.com/problems/department-top-three-salaries/ Department Top Three Salaries - 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 The Employee table holds all employees. Every employee has an Id, and there is also a column for the depar..

윈도우 함수에서만 가능한 데이터 순위 정하기 1. MySQL ROW_NUMBER Function https://www.mysqltutorial.org/mysql-window-functions/mysql-row_number-function/ MySQL ROW_NUMBER and Its Useful Applications In this tutorial, you will learn about the MySQL ROW_NUMBER() function and how to use it to generate a unique number for each row in the result set. www.mysqltutorial.org SELECT ROW_NUMBER() OVER ( ORDER BY productName ..

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 The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the departm..

1. MySQL LEAD Function LEAD()함수는 현재 행에서 여러 행을 보고 해당 행의 데이터에 액세스 할 수 있는 윈도우 함수입니다. LAG()함수와 비슷하며, LEAD()기능은 현재 행과 동일한 결과 집합 내의 후속 행과의 차이를 계산하기위해 매우 유용하다. LEAD([,offset[, default_value]]) OVER ( PARTITION BY (expr) ORDER BY (expr) ) 이 LEAD()함수는 정렬된 파티션 expression의 offset-th행에서의 값을 반환합니다 . 예시) orders and customers tables SELECT customerName, orderDate, LEAD(orderDate,1) OVER ( PARTITION BY customer..

180. Consecutive Numbers https://leetcode.com/problems/consecutive-numbers/ Consecutive Numbers - 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 Write a SQL query to find all numbers that appear at least three times consecutively. -- 윈도우함수로 풀기 SELECT DISTINCT l.Num AS ConsecutiveN..

196. Delete Duplicate Emails https://leetcode.com/problems/delete-duplicate-emails/ Delete Duplicate Emails - 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 Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its sma..

627. Swap Salary https://leetcode.com/problems/swap-salary/ Swap 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 Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice versa) with a..

181. Employees Earning More Than Their Managers https://leetcode.com/problems/employees-earning-more-than-their-managers/ Employees Earning More Than Their Managers - 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 The Employee table holds all employees including their managers. Ev..