 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):
5316/
99
|
|
|
|
| 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:
Answer to sanjeet's question
Name:
Deepankar Sarangi (Auther)
Date:
11/27/2008 2:35:45 AM
Comment:
select * from emp where rownum <16;
EMPNO ENAME ROWID
---------- ---------- ------------------
7369 SMITH AAAHW7AABAAAMUiAAA
7499 ALLEN AAAHW7AABAAAMUiAAB
7521 WARD AAAHW7AABAAAMUiAAC
7566 JONES AAAHW7AABAAAMUiAAD
7654 MARTIN AAAHW7AABAAAMUiAAE
7698 BLAKE AAAHW7AABAAAMUiAAF
7782 CLARK AAAHW7AABAAAMUiAAG
7788 SCOTT AAAHW7AABAAAMUiAAH
7839 KING AAAHW7AABAAAMUiAAI
7844 TURNER AAAHW7AABAAAMUiAAJ
7876 ADAMS AAAHW7AABAAAMUiAAK
7900 JAMES AAAHW7AABAAAMUiAAL
7902 FORD AAAHW7AABAAAMUiAAM
7934 MILLER AAAHW7AABAAAMUiAAN
select * from emp where rownum <8 minus select * from emp where rownum <7;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
|
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,
|
|
|
|
|
|
