var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 Simple queries
* 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
Muhammad Owais Bilal Awan
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
Visit the new-look IDUG Website
, register to gain access to the excellent content.