Saturday, March 17, 2012

Cummulative Sum or Running Totals in SQL Oracle

select ename,sum(sal),sum(sum(sal)) over (order by ename)  from emp group by ename;


No comments:

Post a Comment