Skip to main content

Employees Earning More Than Their Manager

Learn Employees Earning More Than Their Manager (Advanced SQL Interview Problems, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A self join treats the same table as two roles: employee (e) and manager (m), linked by manager_id. Then compare their salaries.

More lessons in Advanced SQL Interview Problems