Running Total in Query
Posted: Tue Apr 25, 2006 2:21 am
SELECT ename , deptno , sal ,
SUM(sal)
OVER (order by ename) "Running Total"
from emp
order by ename;
ENAME DEPTNO SAL Running Total
---------- ---------- ---------- -------------
ADAMS 20 1100 1100
ALLEN 30 1600 2700
BLAKE 30 2850 5550
CLARK 10 2450 8000
FORD 20 3000 11000
JAMES 30 950 11950
JONES 20 2975 14925
KING 10 5000 19925
MARTIN 30 1250 21175
MILLER 10 1300 22475
SCOTT 20 3000 25475
Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693
SUM(sal)
OVER (order by ename) "Running Total"
from emp
order by ename;
ENAME DEPTNO SAL Running Total
---------- ---------- ---------- -------------
ADAMS 20 1100 1100
ALLEN 30 1600 2700
BLAKE 30 2850 5550
CLARK 10 2450 8000
FORD 20 3000 11000
JAMES 30 950 11950
JONES 20 2975 14925
KING 10 5000 19925
MARTIN 30 1250 21175
MILLER 10 1300 22475
SCOTT 20 3000 25475
Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693