Home » SQL & PL/SQL » SQL & PL/SQL » query to find second highest sal
query to find second highest sal [message #223855] Mon, 12 March 2007 01:59 Go to next message
sheevaraj
Messages: 2
Registered: February 2007
Location: chennai
Junior Member

How to find the second highest salary in the query.
Re: query to find second highest sal [message #223869 is a reply to message #223855] Mon, 12 March 2007 02:52 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this OraFAQ page which shows some techniques of how to select the top 'n' rows from a table; adjust one of them in order to get the answer to your question.

BTW, it has nothing to do with Forms Developer.
Re: query to find second highest sal [message #223878 is a reply to message #223869] Mon, 12 March 2007 03:11 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And if the FAQ page isn't enough, search the board.

http://www.orafaq.com/forum/fa/448/0/

MHE
Previous Topic: difference between cursor and refcursor ?
Next Topic: Help me in writing trigger
Goto Forum:
  


Current Time: Mon Dec 05 09:11:08 CST 2016

Total time taken to generate the page: 0.10917 seconds