DEPT_NO FROM DEPT WHERE
| SELECT DEPT. DEPT_NO FROM DEPT WHERE (SELECT COUNT(*) FROM EMP, DEPT WHERE EMP.DEPT_NO = DEPT.DEPT_NO AND PRO.PRO_MNG = EMP.EMP_NO ) >= 1; |
| Пример 14.16.3. |
| Закрыть окно |
Введение в модель данных SQL
| SELECT DEPT. DEPT_NO FROM DEPT WHERE (SELECT COUNT(*) FROM EMP, DEPT WHERE EMP.DEPT_NO = DEPT.DEPT_NO AND PRO.PRO_MNG = EMP.EMP_NO ) >= 1; |
| Пример 14.16.3. |
| Закрыть окно |