AS MAX_SAL FROM EMP GROUP
| SELECT DEPT_NO, EMP_BDATE, MAX (EMP_SAL) AS MAX_SAL FROM EMP GROUP BY ROLLUP (DEPT_NO, EMP_BDATE); |
| Пример 16.1. |
| Закрыть окно |
Введение в модель данных SQL
|
|
|
| SELECT DEPT_NO, EMP_BDATE, MAX (EMP_SAL) AS MAX_SAL FROM EMP GROUP BY ROLLUP (DEPT_NO, EMP_BDATE); |
| Пример 16.1. |
| Закрыть окно |