SELECT job,deptno,round(avg(sal),2 ) "avg", SUM(sal)"sum" FROM emp where job != 'PRESIDENT' GROUP BY ROLLUP(job,deptno) ORDER BY job,deptno
| SQL_GROUPBY_ROLLUP1 |
Script:
|
| At present ROLLUP is not supported in PostgreSQL, similar result can be achieved using UNION joins. |
| Oracle:
|
| POSTGRESQL
|