Skip to content
SQLSimplified
mediumemployeesjoingroup-byhaving

Top Paying Department

Problem

Return the department with the highest average salary (its name and avg_salary), using a grouped query limited to one row.

Try It

Employees & Departments

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems