목록self join (1)

HAZEL

[SQL : HackerRank/Leetcode] SELF JOIN

1. 181. Employees Earning More Than Their Managers >> 문제 The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +----+-------+--------+-----------+ | Id | Name | Salary | ManagerId | +----+-------+--------+-----------+ | 1 | Joe | 70000 | 3 | | 2 | Henry | 80000 | 4 | | 3 | Sam | 60000 | NULL | | 4 | Max | 90000 |..
DATA ANALYSIS/SQL 2021. 2. 13. 22:24
이전 Prev 1 Next 다음