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..
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:
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.
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
,
author & internet detective
staff