Sentencia sql de hr

[huesos52]

Código SQL:

SELECT 
d.department_name,
e.first_name,  
t1.sal_max 
FROM employees e 
INNER JOIN
(
SELECT department_id, 
MAX(salary) sal_max 
FROM 
employees 
GROUP BY department_id
) t1
ON 
e.department_id=t1.department_id
INNER JOIN
departments d
ON d.department_id=t1.department_id;
 

Creo que así te debe salir.
No tengo como probar en un oracle Express.

Nos cuentas como te va.