SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To find the nth highest/lowest value in a table

edy12Jun 25 2014 — edited Jun 25 2014

Hi All

I have a question

in the table a1(empid,sal) are the 2 columns

empid sal

100 5000

105 7500

110 3500

087 11136

95 14336

No I want to write the query which will give me the 3rd highest salary. or to generalize it to find the nth highest/nth lowest value from the table.

Note:- Rownum or Rowid is not to be used

Thanks

This post has been answered by $agar$ on Jun 25 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2014

Added on Jun 25 2014

11 comments

1,835 views