Last updated on October 10th, 2024 at 12:03 am

This Leetcode problem Employees Earning More Than Their Managers LeetCode Solution is done in SQL.

List of all LeetCode Solution

Employees Earning More Than Their Managers LeetCode Solution

Problem Statement

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:

Output:

Explanation: Joe is the only employee who earns more than his manager.

1. Employees Earning More Than Their Managers LeetCode Solution 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;