thiyagarajanc

 Profile Answers by thiyagarajanc Questions by thiyagarajanc

• Dec 1st, 2005

 

select

        sal

from

        (select sal from emp order by sal desc)

where

        rownum <= 3;

Rishi

• Dec 5th, 2005

 

SELECT sal
FROM (SELECT sal FROM my_table ORDER BY sal DESC)
WHERE ROWNUM < 4;

kalyan

• Dec 20th, 2005

 

hai

 there is max function in Informatica use it.

kalyan

Ray Anthony

• Mar 22nd, 2006

 

since this is informatica.. you might as well use the Rank transformation.  check out the help file on how to use it.

Cheers,

Ray Anthony

Deshmukh Sachin

• Apr 25th, 2006

 

select max(sal) from emp;

prasad

• Apr 27th, 2006

 

 the following is the query to find out the top three salaries

in ORACLE:--(take emp table)

select * from emp e where 3>(select count (*) from emp where

e.sal>emp.sal) order by sal desc.

in SQL Server:-(take emp table)

select top 10 sal from emp

Neeraj

• Nov 7th, 2006

 

You can write the query as follows.SQL> select * from 2 (select ename,sal from emp order by sal desc) 3 where rownum<=3;