Home » SQL & PL/SQL » SQL & PL/SQL » query
query [message #9236] Tue, 28 October 2003 06:20 Go to next message
saravanan
Messages: 70
Registered: October 2000
Member
hi,

anybody helpme to write a query for top three highest salary from an table.

regards,

vp sarravanan

Report message to a moderator

Re: query [message #9237 is a reply to message #9236] Tue, 28 October 2003 07:03 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Look at the SQL Experts forum for a similar question...and an answer.

MHE

Report message to a moderator

Answer to the query [message #9250 is a reply to message #9236] Wed, 29 October 2003 04:30 Go to previous message
sprs
Messages: 2
Registered: October 2003
Junior Member
The following query will return the top three salary

SELECT empno, sal
FROM Emp e1
WHERE 3 > (SELECT COUNT(*) FROM Emp e2
WHERE e1.sal < e2.sal)
ORDER BY SAL desc

Report message to a moderator

Previous Topic: Need help with an exception
Next Topic: need query to fetch data in specific format
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 05:01:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.