#12 Employees with the Highest Salary in Their Department

Companies:

VTB Innotech

Themes:

SQLSubqueriesPractice

The domain model of the Horns and Hooves company is represented by the Department and Employee tables. Return the list of employees (id, name) who receive the highest salary in their department.

Department
id | name
...

Employee
id | department_id | name | salary
...

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.