 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
CodeSnip: Selecting the nth Record from a Table Using Oracle
|
Published:
01 Feb 2008
|
Abstract
In this code snippet, Deepankar examines the usage of Oracle's ROWNUM keyword to select the nth row of a table. It also deals with the other possible methods of selection along with the risks involved in using them. The article begins with a short introduction followed by relevant SQL code with explanation and screenshots. |
 |
by Deepankar Sarangi
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
3663/
158
|
|
|
|
| Introduction |
In order to follow the article you will require Oracle 9i or
an above version. ROWNUM is a virtual column, which is available in a query.
|
|
|
|
|
Article Feedback
User Comments
Title:
question
Name:
sanjeet
Date:
5/27/2008 1:19:09 AM
Comment:
Question: display the 7th record of emp table with using rownum.
Question: delete all duplicate records except one record from emp table as empno. , ename, salary,
|
|
|
|
|
|
