 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
CodeSnip: Selecting nth Highest Value of a Column Using Oracle
|
Published:
04 Feb 2008
|
Abstract
In ths code snippet, Deepankar demonstrates how to select the nth highest value of a column from any table in an Oracle database. He begins by introducing a SQL query and providing a short explanation about it. The final sections of the article examine how to perform validation in two different code samples by querying a table. |
 |
by Deepankar Sarangi
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
21575/
95
|
|
|
|
| Introduction |
This code snippet will allow the viewer to select the nth
highest value of a column from any table in Oracle database. This article also
deals with the other possible methods of selection along with the risks
involved in using them.
|
|
|
|
User Comments
Title:
excellant
Name:
uttam
Date:
2010-01-22 8:48:00 AM
Comment:
simply superb
|
Title:
superb
Name:
Amit Verma
Date:
2009-12-14 8:19:52 AM
Comment:
really good solution
|
Title:
Nice and easy query
Name:
SB
Date:
2009-12-01 6:47:42 AM
Comment:
Very much self explanatory. thanks for sharing.
|
Title:
Another way to do it
Name:
Pat
Date:
2009-11-13 3:46:08 PM
Comment:
I dunno, this SQL seems to be faster, on my database anyway:
SELECT EMPLOYEE_ID
FROM (SELECT EMPLOYEE_ID FROM emp ORDER BY EMPLOYEE_ID desc)
WHERE rownum < 2;
I killed the examples after ten minutes of waiting each. My SQL ran in 2-3 minutes (depending on time of day). The table I'm running these on has over 4.5 million records.
|
Title:
Was really helpful
Name:
Srinivas
Date:
2008-12-24 1:35:12 PM
Comment:
Hi Deepankar,
I was working on oracle for the first time and ur code snippet example helped me a lot.
Thanks
|
Title:
Thanks friend
Name:
Chittaranjan
Date:
2008-04-05 6:00:00 AM
Comment:
hi, deepankar. i'm really glad that u have found out this answer. it will really help others.
|
Title:
Thanks
Name:
Aroop
Date:
2008-03-10 12:05:40 PM
Comment:
Awesome Deepankar...!!
|
Title:
Thanks Deepankar
Name:
Ajay
Date:
2008-03-10 11:58:35 AM
Comment:
Hi Deepankar,
I was searching this query from last few days .
Thanks a lot for this.
Regards,
Aj
|
|
|
|
|
|
