WHERE DEPT_NO IS NOT

SELECT DEPT_NO
FROM EMP
WHERE DEPT_NO IS NOT NULL
GROUP BY DEPT_NO
HAVING COUNT(*) = 30;

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

---