Sample Ex#1
-------------------------
Expand|Select|Wrap|Line Numbers
- SELECT HIREDATE,SUM(SAL) "SALARY",SUM(SUM(SAL)) OVER (ORDER BY HIREDATE ROWS BETWEEN
- UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) "TOTALSALARY"
- FROM EMP
- GROUP BY HIREDATE
- ORDER BY HIREDATE;
-------------------------
Expand|Select|Wrap|Line Numbers
- SELECT HIREDATE,
- SUM(SAL) "SALARY",
- SUM(SUM(SAL)) OVER (ORDER BY HIREDATE ROWS BETWEEN
- UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) "WINDOWSALARY" ,
- SUM(SUM(SAL)) OVER() "REPORTINGSALES"
- FROM EMP GROUP BY HIREDATE ORDER BY HIREDATE;
Sample Example #3
==================
Expand|Select|Wrap|Line Numbers
- SELECT HIREDATE,SUM(SAL) "SALARY",
- SUM(SUM(SAL)) OVER() "REPORTINGSALES"
- FROM EMP
- WHERE JOB='MANAGER'
- GROUP BY HIREDATE ORDER BY HIREDATE;
Sample Example #4
==================
Expand|Select|Wrap|Line Numbers
- SELECT DEPTNO,EMPNO,SUM(SAL)"SALARY",SUM(SUM(SAL)) OVER(PARTITION BY DEPTNO) "DEPTSAL"
- FROM EMP
- GROUP BY DEPTNO,EMPNO
- ORDER BY DEPTNO,EMPNO
---------------------------------------
Sample Ex#5
=============
Expand|Select|Wrap|Line Numbers
- SELECT DEPTNO,
- EMPNO,
- SUM(SAL)"SALARY",
- ROUND(SUM(SAL)/SUM(SUM(SAL)) OVER(PARTITION BY DEPTNO),2) "DEPTPERCENT"
- FROM EMP
- GROUP BY DEPTNO,EMPNO
- ORDER BY DEPTNO,EMPNO;
Sample Ex#6
=============
Expand|Select|Wrap|Line Numbers
- SELECT DEPTNO,
- EMPNO,
- SUM(SAL)"SALARY",
- ROUND(RATIO_TO_REPORT(SUM(SAL)) OVER(PARTITION BY DEPTNO),2) "DEPTRATIO"
- FROM EMP
- GROUP BY DEPTNO,EMPNO
- ORDER BY DEPTNO,EMPNO;