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..
Joined: Sep 13, 2002
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:
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
Joined: Jun 09, 2002
i've found the solution to my problem already.. thanks a lot..
Joined: Oct 23, 2003
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.
Joined: Feb 28, 2003
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.