Return the highest-salary employee in each department with c…
Return the highest-salary employee in each department with columns: department_name, employee_id, full_name, salary. No tie handling required. Employees( employee_id NUMBER, first_name VARCHAR2(50),last_name VARCHAR2(50), department_id NUMBER, salary NUMBER)Departments( department_id NUMBER, department_name VARCHAR2(100))