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
Ranch Hand
Joined: Sep 13, 2002
Posts: 331
posted
0
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"
Conie Ooi
Ranch Hand
Joined: Jun 09, 2002
Posts: 31
posted
0
i've found the solution to my problem already.. thanks a lot..
timothy passcal
Greenhorn
Joined: Oct 23, 2003
Posts: 9
posted
0
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
Ranch Hand
Joined: Feb 28, 2003
Posts: 227
posted
0
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.
0
