SQL Join for Max Salary | Dataford Interview Questions

Write an SQL query using joins to find the employee with the maximum salary in a department.

Return every employee tied for the highest non-null salary in each department. Departments without an eligible employee should be excluded.

Output

One row per qualifying employee, with department_name, employee_id, employee_name, and salary.
Sort by department_name ascending, then employee_id ascending.

departments

Column	Type	Description
department_idPK	INTEGER	Unique department identifier
department_name	VARCHAR(100)	Department name

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INTEGER	Employee department identifier
salary	NUMERIC(12,2)	Employee salary

Your question is SQL Join for Max Salary. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.