sad

• Nov 24th, 2006

 

select MAX(sal),sum(sal) from table_name;

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 24th, 2006

 

Hi friend,

     I have a query to find the answer to ur question.that is

  select distinct(a.sal) from emp a where 3>=(select count(distinct(sal)) from emp b
where a.sal<=b.sal)  order by sal desc;

  It displays 3 max sals.

 regards.

Rukmaj Chandavar

• Dec 29th, 2006

 

you can try this query as an alternative, this is very simple

select * from (select distinct sal from emp order by sal desc) where rownum < 4

this gives top 3 salaries. You can add sum function on outer select query to get the sum of same.

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

 

YOU CAN USE DENSE RANK TO RETRIEVES MAX SALARIES AND EMPLOYEES DETAILSSELECT * FROM ( SELECT A.* ,DENSE_RANK () OVER ( ORDER BY SALARY DESC ) R FROM EMPLOYEES A) WHERE R<=3YOU WILL GT MAX THREE SALARIES EMPLOYEES DETAILS IN ORACLE ( TOTAL 4 ROWS)YOU CAN EDIT THIS TO GET THREE SALARIES ALSO

gtomar

 Profile Answers by gtomar 

• Jul 25th, 2008

 

select sum(sal) from (select distinct sal from emp order by sal desc) where rownum < 4

try this