SELECT DISTINCT

SELECT DISTINCT DEPT_NO
FROM EMP
WHERE (SELECT COUNT (*)
FROM EMP EMP1
WHERE EMP1.DEPT_NO = EMP.DEPT_NO) = 30;

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

---