CodeSnip: Selecting nth Highest Value of a Column Using Oracle
page 1 of 4
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): 3709/ 131

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.


View Entire Article

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 5 and 6 and type the answer here:

User Comments

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






Ads Powered by Lake Quincy Media
Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2008 ASPAlliance.com  |  Page Processed at 9/7/2008 10:58:02 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search