FROM DEPT,

SELECT DEPT.DEPT_NO, (SELECT COUNT(*)
FROM EMP
WHERE DEPT.DEPT_NO = EMP.DEPT_NO)
FROM DEPT, EMP
WHERE DEPT.DEPT_MNG = EMP.EMP_NO AND
EMP.DEPT_NO IS NULL;

Содержание  Назад  Вперед

---