Home » SQL & PL/SQL » SQL & PL/SQL » how to get top 3 salaries for each dept
how to get top 3 salaries for each dept [message #255408] Tue, 31 July 2007 13:40 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I want to retrieve the top 3 salaries for each department number or the department name.

Like

NAME DEPTNO DNAME SAL
________________________________

X 10 HR 5000
R 10 HR 4500
P 10 HR 3000

G 20 OP 6000
T 20 OP 5000
S 20 OP 4000


Can somebody help me in getting this query.

Regards,

Raj
Re: how to get top 3 salaries for each dept [message #255410 is a reply to message #255408] Tue, 31 July 2007 13:44 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for top N.
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: rows as columns
Next Topic: ORA-00942
Goto Forum:
  


Current Time: Thu Dec 08 02:19:09 CST 2016

Total time taken to generate the page: 0.13488 seconds