My requirment is to get the sum(sal) on top & then individual salaries in a rollup function . How can i get this.
Say if i have
select deptno , sum(sal) group by rollup(deptno)
i get the sum(sal) for each deptno below the individual salaries in each dept.
What i want is sum(sal) of each dept as the first entry in my resultset sql query & then followed by individual salaries of that