Home » SQL & PL/SQL » SQL & PL/SQL » 3rd maximum salary of an employee query (Oracle,, Solaris)
3rd maximum salary of an employee query [message #284543] Fri, 30 November 2007 00:35 Go to next message
Messages: 31
Registered: October 2007
Location: Bangalore

Any can tell me the (efficient)query for extracting 3rd max salary of an employee.

table name: emp

Fileds name: ename varchar2(5), salary number, enumber number;

Thanks in advance.........
Re: 3rd maximum salary of an employee query [message #284546 is a reply to message #284543] Fri, 30 November 2007 00:41 Go to previous message
Michel Cadot
Messages: 65082
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are many queries that have been described many and many times here.
The best one depend on your data and indexes.

Search fro "Top N".
Previous Topic: creating a view at run-time by using pl/sql procedure
Next Topic: problem in creating Hash Partition
Goto Forum:

Current Time: Fri Jul 21 05:48:40 CDT 2017

Total time taken to generate the page: 0.12579 seconds