목록185. Department Top Three Salaries (1)

HAZEL

[SQL : 서브쿼리 / INNER JOIN / WINDOW FUNCTION ] LeetCode: 185. Department Top Three Salaries

185. Department Top Three Salaries >> 문제 The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id. +----+-------+--------+--------------+ | Id | Name | Salary | DepartmentId | +----+-------+--------+--------------+ | 1 | Joe | 85000 | 1 | | 2 | Henry | 80000 | 2 | | 3 | Sam | 60000 | 2 | | 4 | Max | 90000 | 1 | | 5 | Janet | 69000 | 1 | |..
DATA ANALYSIS/SQL 2021. 5. 13. 00:08
이전 Prev 1 Next 다음