Hi,
D2k is new product for me, I have a question for example

select deptno, ename, sal, hiredate
from emp

I need the subtotal of sal by deptno & then grand total. How I can do that.

Thanks in advance.