CodeSnip: Selecting nth Highest Value of a Column Using Oracle: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
CodeSnip: Selecting nth Highest Value of a Column Using Oracle

page 4 of 4

by Deepankar Sarangi
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 5222/ 99

Article Contents:

Conclusion

Both the methods explained above are well and good. The first one does not use any oracle function. Where it is explicitly asked not to use any functions this approach can be followed.

But the second approach does the same through RANK () OVER () function. Many other useful facts about the RANK () OVER () function can be revealed by exploring it more.

« (Page 3)

View Entire Article

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 5 and 7 and type the answer here:

User Comments

Title: Was really helpful
Name: Srinivas
Date: 12/24/2008 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: 4/5/2008 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: 3/10/2008 12:05:40 PM
Comment:
Awesome Deepankar...!!

Title: Thanks Deepankar
Name: Ajay
Date: 3/10/2008 11:58:35 AM
Comment:
Hi Deepankar,

I was searching this query from last few days .
Thanks a lot for this.

Regards,
Aj