Hello;

* Can anybody help me in writing a simple query to get data ranging from record # 50 to record # 75 in the query below:

SELECT * FROM DB2ADMIN.ST_ITEM

* Also how to generate unique id for primary key.

Thanking you in an advance


With Regards

Muhammad Owais Bilal Awan

with temp(rid,col1,col2)
as
(
select rownumber() over () ,col1,col2 from DB2ADMIN.ST_ITEM fetch first 75 rows only
)
select * from temp where rid between 50 and 75
is one option

Sathyaram