EMP_NAME FROM EMP, EMP EMP1
SELECT DISTINCT EMP.EMP_NO, EMP. EMP_NAME FROM EMP, EMP EMP1 WHERE EMP.DEPT_NO = 65 AND EMP.EMP_NAME = EMP1.EMP_NAME AND EMP.DEPT_NO = EMP1.DEPT_NO AND EMP.EMP_NO <> EMP1.EMP_NO; |
Пример 14.22.3. |
Закрыть окно |
SELECT DISTINCT EMP.EMP_NO, EMP. EMP_NAME FROM EMP, EMP EMP1 WHERE EMP.DEPT_NO = 65 AND EMP.EMP_NAME = EMP1.EMP_NAME AND EMP.DEPT_NO = EMP1.DEPT_NO AND EMP.EMP_NO <> EMP1.EMP_NO; |
Пример 14.22.3. |
Закрыть окно |