GROUP WISE SUM

---group wise sum...
--- SHOWING THE GROUP SUM TO EACH ROWS
--- USE OF PARTITION BY

select ename , deptno, sal,
sum(sal) over (partition by deptno) total_salary
from SCOTT.EMP
order by deptno