How to select resultset in range?

[Conie Ooi]

Hi, I'm in a situation which I need to select rows from table in a range, let's say from record 3 to record 5. Is there any command in DB2 can do the job for me?
Thanks a lot and waiting for your reply..

[Blake Minghelli]

Can you explain a little more what you're trying to do? It seems a little odd that you need to select rows 3-5 in a table like that. Isn't there a specific field value(s) you can add to your WHERE clause to identify the records you need? Sorry, maybe I'm just misunderstanding you :roll:

[Conie Ooi]

i've found the solution to my problem already.. thanks a lot..

[timothy passcal]

I know this thread is really old....
Does anyone have a solution on how to do this in DB2?
Select * from X where database returns only rows 21 through 30.
Thanks.

[Dana Hanna]

I can't fully answer this, but I can send you in the right direction:
adding
"FETCH FIRST 40 ROWS ONLY"
to your SQL statement gets the first 40, but I don't think you can tell it to drop the first X amount.

[Jeanne Boyarsky]

dbForums has a good thread on this. You can do it with a nested query, but it will be very inefficient.