SHEEL2006

• Feb 26th, 2007

 

select  sum(salary) from  emp   minus     (select distinct(a.sal) from emp a where &n =(select  count(distinct(b.sal)) from emp b where a.sal<=b.sal)

arun_doss

 Profile Answers by arun_doss 

• Mar 13th, 2008

 

SELECT empno, sal, ( SELECT SUM ( a.sal ) 
                                      FROM emp a ) total_sal
   FROM emp;

sumanta.bala

 Profile Answers by sumanta.bala 

• Jun 5th, 2009

 

SELECT ename,

deptno,

sal,

TRUNC (AVG (sal) OVER (PARTITION BY deptno)) avg_sal

FROM scott.emp