Home » SQL & PL/SQL » SQL & PL/SQL » Finding second highest salary
Finding second highest salary [message #251970] Tue, 17 July 2007 10:22 Go to next message
avrillavinge
Messages: 98
Registered: July 2007
Member
Hi all .

can anyone help me with syntax to find the second highest salary .

using rownum i can find top 3 salaries how do i find find the 2nd highest salary

Plz help ..
Re: Finding second highest salary [message #251972 is a reply to message #251970] Tue, 17 July 2007 10:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You find answer to this FAQ by searching for "TOP N"
Re: Finding second highest salary [message #251977 is a reply to message #251970] Tue, 17 July 2007 10:37 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Topic closed.
./fa/448/0/
Regards
Michel
Previous Topic: select dump
Next Topic: Sql query
Goto Forum:
  


Current Time: Sat Dec 10 16:42:29 CST 2016

Total time taken to generate the page: 0.05243 seconds