Last updated on January 22nd, 2025 at 11:22 pm
Here, we see the Employees Earning More Than Their Managers LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.
List of all LeetCode Solution
Level of Question
Easy

Employees Earning More Than Their Managers LeetCode Solution
Table of Contents
1. Problem Statement
Column Name | Type |
id | int |
name | varchar |
salary | int |
managerId | int |
Employee
id is the primary key (column with unique values) for this table. Each row of this table indicates the ID of an employee, their name, salary, and the ID of their manager.
Write a solution to find the employees who earn more than their managers.
Return the result table in any order.
The result format is in the following example.
Example 1:
Input:
id | name | salary | managerId |
1 | Joe | 70000 | 3 |
2 | Henry | 80000 | 4 |
3 | Sam | 60000 | Null |
4 | Max | 90000 | Null |
Output:
Employee |
Joe |
Explanation: Joe is the only employee who earns more than his manager.
2. Code Implementation in Different Languages
2.1 Employees Earning More Than Their Managers MySQL
select e.Name as Employee from Employee as e inner join Employee as m on e.ManagerId = m.id where e.Salary > m.Salary;