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: 25571
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: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Topic closed.
./fa/448/0/
Regards
Michel
Previous Topic: ORA-02291: integrity constraint violated - parent key not found
Next Topic: Drop objects
Goto Forum:
  


Current Time: Sat Aug 19 15:44:12 CDT 2017

Total time taken to generate the page: 0.19014 seconds