OraFAQ Forum: Server Administration

Sun, 22 April 2001 02:52

Hanumantha Raju
Messages: 7
Registered: April 2001

Junior Member

How can i dislplay the third highest salary drawing empno in emp table.

Mon, 23 April 2001 02:33

Balamurugan.R
Messages: 91
Registered: March 2001

Member

Hi,

Try this

select empno from emp x where 3=(select count(distinct(sal)) from emp where x.sal<=sal);

Cheers,
Balu

Mon, 23 April 2001 15:24

Jaco
Messages: 23
Registered: August 2000

Junior Member

SELECT MAX(SAL) FROM EMP WHERE SAL<(SELECT MAX(SAL) FROM EMP
WHERE SAL < (SELECT MAX(SAL) FROM EMP))

Previous Topic:	how do u I write this sql query
Next Topic:	Is there a way to remove duplicates from a table?

Goto Forum:

]

Current Time: Mon Dec 23 09:38:23 CST 2024