✅ 100% EASY || FAST 🔥|| CLEAN SOLUTION 🌟
Code\n\n/* Write your PL/SQL query statement below */\nSELECT DEPT.name AS Department, EMP.name AS Employee, EMP.salary AS \n\nSalary FROM Department DEPT, Empl
# Code\n```\n/* Write your PL/SQL query statement below */\nSELECT DEPT.name AS Department, EMP.name AS Employee, EMP.salary AS \n\nSalary FROM Department DEPT, Employee EMP WHERE\n\nEMP.departmentId = DEPT.id AND (EMP.departmentId, salary) IN \n\n(SELECT departmentId, MAX (salary) FROM Employee GROUP BY \n\ndepartmentId)\n```\nIF THIS WILL BE HELPFUL TO YOU,PLEASE UPVOTE !\n\n![5kej8w.jpg](https://assets.leetcode.com/users/images/c29d80c7-fd85-4816-8171-ebf71ef130fa_1690526222.9120727.jpeg)\n\n\n
['Database', 'MySQL', 'Oracle', 'MS SQL Server']