View previous topic :: View next topic
|
Author |
Message |
ameenansari
New User
Joined: 18 Sep 2006 Posts: 11 Location: chennai
|
|
|
|
I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys) |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Ameen,
What do you mean by "record num"? |
|
Back to top |
|
|
ameenansari
New User
Joined: 18 Sep 2006 Posts: 11 Location: chennai
|
|
|
|
I want the records from 100 t0 200 |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Ameen,
You cannot compare DB2 tables with flat files wherein we can extract the nth record or a set of records, say 100th to 200th.
AFAIK, There is no such record number concept in DB2. |
|
Back to top |
|
|
Cristopher
New User
Joined: 31 Jul 2008 Posts: 53 Location: NY
|
|
|
|
Ameenansari,
What is the actual business requirement behind this request .If you can explain that...someone would surely be able to help u with it.
Cris |
|
Back to top |
|
|
aluru_m
New User
Joined: 22 May 2008 Posts: 5 Location: New Jersey
|
|
|
|
You can fetch the records using ROWID |
|
Back to top |
|
|
|