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.

Report message to a moderator

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: 21826
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.

Report message to a moderator

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: 7065
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 16 06:57:35 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.