simple and easy solution || MySQL
\n# if it\'s help, please up \u2B06 vote! \u2764\uFE0F\n\n###### Let\'s Connect on LinkedIn: www.linkedin.com/in/shishirrsiam\n###### Let\'s Connect on Facebook
\n# if it\'s help, please up \u2B06 vote! \u2764\uFE0F\n\n###### Let\'s Connect on LinkedIn: www.linkedin.com/in/shishirrsiam\n###### Let\'s Connect on Facebook: www.fb.com/shishirrsiam\n\n# Code\n```mysql []\nselect dp.name as Department, em.name as Employee, em.salary\nfrom Employee as em join Department as dp \non em.departmentId = dp.id \nwhere em.salary = ( select max(salary) from Employee where departmentId = dp.id )\n```
['Database', 'MySQL']