✅ 100% EASY || FAST 🔥|| CLEAN SOLUTION 🌟
\n Add your space complexity here, e.g. O(n) \n\n# Code\n\n# Write your MySQL query statement below\nselect department, Employee, salary from(\nselect d.name as
\n<!-- Add your space complexity here, e.g. $$O(n)$$ -->\n\n# Code\n```\n# Write your MySQL query statement below\nselect department, Employee, salary from(\nselect d.name as department,e.name as Employee,e.salary, dense_rank() over(partition by d.name order by salary desc) as rank_\n from Employee e join department d on e.departmentId=d.id\n) as Table1\nwhere rank_=1\n```
['MySQL']