Skip to main content

Department-wise Highest Salary & Top 3 per Department

Learn Department-wise Highest Salary & Top 3 per Department (Advanced SQL Interview Problems, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction The highest salary per department: aggregate in a subquery, then join back to find who earns it (ties return every top earner).

More lessons in Advanced SQL Interview Problems