Введение в модель данных SQL



Пример 15.15


SELECT SUM (TOTAL_EMP), MAX_SAL

FROM (SELECT MAX (EMP_SAL), COUNT (*)

FROM EMP

WHERE DEPT_NO IS NOT NULL

GROUP BY DEPT_NO ) AS DEPT_MAX_SAL (MAX_SAL, TOTAL_EMP)

GROUP BY MAX_SAL;




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