Home » RDBMS Server » Server Utilities » Display top 3rd Employee Salary
Display top 3rd Employee Salary [message #71384] Thu, 24 October 2002 12:48 Go to next message
SSV
Messages: 11
Registered: October 2002
Junior Member
How to write a Query that will display a top 3rd employee salary

Please help soon, Urgent

Thanks in advance

Report message to a moderator

Re: Display top 3rd Employee Salary [message #71385 is a reply to message #71384] Fri, 25 October 2002 02:17 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
select emp_name,salary from ( select emp_name,salary from YOUR_TABLE
order by salary desc )
where rownum < 4

Report message to a moderator

Previous Topic: database connection
Next Topic: Tablespace Defragmentation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 19:33:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.