Question

A company maintains data on their employees in a table called employee. Write a query to find the highest paid employee in each department. The output should contain department_name, employee_name, and salary. Exclude employees with no department from your result.

 Input Format: 

employee table: 

Column Type 

employee_no Integer 

employee_name String 

department_no Integer 

salary Integer 

manager_no Integer 

department table: 

Column Type 

department_no String 

department_name String

Answer 1

Answer:

Select d.department_name,e.employee_name,e.salary from employee e JOIN department d ON e.department_no = d.department_no GROUP BY d.department_no having e.salary = MAX(e.salary);

Answer 2

[REMOVED]