Hi,

I have a db2 table with 600 rows.

I need to write 3 sql queries

the first query should retrieve first 200 rows in that table
next query should retrive the next 200 rows from that table
next query should retrive the next 200 rows from that table

i knw how to write the sql query for this req in oracle db but I dnt have any idea about DB2.. can anyone help me on this?

with t1 as (rownum, col1, col2,...) as (
select row_number() over (order by col1),x.*
from mytable as x
) select * from t1 where rownum between 1 and 200

Change the between clause for the other 2 queries.

Andy