What is the function we can use for cummilative total.Example I have sales day wise ,i need to get results for each week it should come cummilative sales

Interview Candidate
Feb 24th, 2006
3
2056

Showing Answers 1 - 3 of 3 Answers

SUNIL KUMAR JHA

Mar 13th, 2006

Hi,This cumualative report can obtained by using RollUp function or Cube function in SQL.Example:--select empno,ename,sum(sal),avg(sal) from emp group by rollup(empno,ename);Try it. It will definitely work.

satyanarayana

Apr 5th, 2006

What is the function we can use for cummilative to.tal function

narendra

Feb 16th, 2007

Rollup Note: ROLLUP enables a SELECT statement to calculate multiple levels of subtotals across a specified group of dimensions. It also calculates a grand total. ROLLUP is a simple extension to the GROUP BY clause, so its syntax is extremely easy to use. The ROLLUP extension is highly efficient, adding minimal overhead to a query.select deptno,sum(sal),avg(sal) from emp group by rollup(deptno);