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

Hi
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: 64139
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".
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: creating a view at run-time by using pl/sql procedure
Next Topic: problem in creating Hash Partition
Goto Forum:
  


Current Time: Thu Dec 08 16:07:41 CST 2016

Total time taken to generate the page: 0.09880 seconds