bhamarekm
New User
Joined: 20 Sep 2010 Posts: 9 Location: Pune
|
|
|
|
Hi Team,
I have to design a query in DB2 and my requirement is as follow
Select * from table;
Suppose above query will give 100 rows as output.
But I want to get display rows from 10 to 20 first time.
Next time I might want to display rows from 20 to 30 or 1 to 10, so it depends on runtime.
Can we retrieve rows within specific range using FETCH clause? if not please provide us any alternative way.
Thanks you for help in advance.
Thanks
Kiran Bhamare |
|