OraFAQ Forum: Server Administration

Mon, 11 June 2001 01:35

amar jyoti dutta
Messages: 2
Registered: June 2001

Junior Member

how to wtite a query which will return the 3rd highest salary from emp table without using the 3 subqueries

Mon, 11 June 2001 08:08

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

select empno, sal
from emp a
where 3 = (select count(*)
from Emp b
where b.sal > a.sal);

Previous Topic:	defining triggers in oracle 8i
Next Topic:	Which is the Perfect Update Statement

Goto Forum:

]

Current Time: Mon Dec 23 14:35:10 CST 2024