1SELECT FIRST_NAME FROM EMPLOYEES
2WHERE SALARY = (SELECT MAX(SALARY) FROM EMPLOYEES);
1/* Highest salary by Department/Location */
2SELECT e.ename, e.sal, e.deptno, d.loc
3FROM emp e
4JOIN dept d
5ON e.deptno = d.deptno
6WHERE e.sal in
7(
8 select max(sal)
9 from emp
10 group by deptno
11)