leetcode]181. Employees Earning More Than Their Managers"/>
[leetcode]181. Employees Earning More Than Their Managers
[leetcode]181. Employees Earning More Than Their Managers
Analysis
心情复杂~—— [ummmmmm~]
Given the Employee table, write a SQL query that finds out employees who earn more than their managers.
SQL语句的使用,在employee表格中找到薪水比其主管高的人,用自连接就可以了。
Implement
# Write your MySQL query statement below
select e1.Name as Employee from Employee e1, Employee e2
where e1.ManagerId = e2.Id and e1.Salary > e2.Salary;
更多推荐
[leetcode]181. Employees Earning More Than Their Managers
发布评论