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: 64718
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: Mon Apr 24 22:07:44 CDT 2017

Total time taken to generate the page: 0.13540 seconds