group by and having || oracle
\n/* Write your PL/SQL query statement below */\nselect d.name department,e.name employee ,e.salary salary from employee e,department d where e.departmentid=d.i
```\n/* Write your PL/SQL query statement below */\nselect d.name department,e.name employee ,e.salary salary from employee e,department d where e.departmentid=d.id and\ne.salary=(select max(distinct salary) from employee group by departmentid having departmentid=e.departmentid);\n```
['Oracle']