EMP_NAME FROM DEPT, EMP WHERE
SELECT DEPT.DEPT_NO, EMP. EMP_NAME FROM DEPT, EMP WHERE DEPT.DEPT_MNG = EMP.EMP_NO AND DEPT.DEPT_NO = EMP.DEPT_NO AND EMP.EMP_SAL = (SELECT MAX(EMP_SAL) FROM EMP WHERE EMP.DEPT_NO = DEPT.DEPT_NO); |
Пример 15.14.1. |
Закрыть окно |