Employees earning more than their manager

Question

An HR compensation review flags reporting pairs where the direct report is paid more than the person they report to.

`staff_roster` stores the manager as a self-reference in `manager_id`. Return `employee_name`, `employee_salary`, `manager_name` and `manager_salary` for every employee whose salary

Accepted Answer

Step 1: Both the employee and the manager live in the same table, so join `staff_roster` to itself using two different aliases — `e` for employee, `m` for manager. Step 2: The relationship is `m.staff_id = e.manager_id`; read it as “the manager row whose id my `manager_id` points to”. Step 3: Use `INNER JOIN` so the top-level employee (whose `manager_id` is `NULL`) is naturally excluded — she has no manager to compare against. Step 4: Apply the compensation test `e.salary > m.salary` in `WHERE`. Step 5: Alias each projected column so the output clearly separates employee-side and manager-side values.

Employees earning more than their manager

More Joins — Self Join questions

Asked at Oracle