OraFAQ Forum: SQL & PL/SQL » 5th highest salary earner

Home » SQL & PL/SQL » SQL & PL/SQL » 5th highest salary earner

Tue, 16 September 2003 05:05

Bipul
Messages: 11
Registered: June 2003

Junior Member

what is the sql statment to see the 5th highest salary earner in a table.

Tue, 16 September 2003 09:41

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Wed, 17 September 2003 04:10

R.Satish Kumar
Messages: 14
Registered: August 2003

Junior Member

Hi,

Here is ur query.

select max(sal) from emp
where level = &no connect by prior sal > sal

Happy querrying..

Satish.R

Previous Topic:	how to find sum of positive salary and sum of negative salary
Next Topic:	EXECUTE IMMEDIATE giving error in Oracle 9i

Goto Forum:

]

Current Time: Thu Apr 25 23:06:25 CDT 2024