数据结构与算法
双指针、回溯剪枝、图论与搜索
🎨 视觉封面LeetCode Employees Earning More Than Their Managers
Problem
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 | NULL |
+----+-------+--------+-----------+
Given the Employee table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe is the only employee who earns more than his manager.
+----------+
| Employee |
+----------+
| Joe |
+----------+
找到比Manager薪水高的雇员
MySQL
SELECT e1.Name AS Employee FROM Employee e1 INNER JOIN Employee e2 ON e1.ManagerId = e2.Id WHERE e1.Salary > e2.Salary;
分析
通过Join解决问题
所有代码开源上传至 GitHub：yummy-code 仓库 · GESP 专题站：GESP WIKI
欢迎加入：C++ GESP/CSP 考级答疑群（688906745） 与 Java/Python交流群（982860385），点击可直接加群。
猜你想读 · 相关文章推荐
LeetCode Combine Two Tables
Problem Table: Person Table: Address Write a SQL query for a report that provides the following information for each person in the Person table, regardless if t...
LeetCode Second Highest Salary
Problem Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the query should return 200 as...
LeetCode Customers Who Never Order
Problem Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything....
OneCoder (lihongzheshuai)
一个中年人的自留地，记录学习 C++、GESP/NOI、Java、Python 与算法架构的心得体会。本站唯一网址：coderli.com