var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
select * from ( select a.*, rownum rnum from (select job, empno from emp order job asc) a )where rnum>=5 and rnum<7
This is query used to retrieve rows 2 rows, i.e., the 5th and 6th rows from the complete query run above. Of course, this is in oracle, but is there a way to do this using db2?
Please let me know, I have been looking for this for a while now.
SELECT * FROM (SELECT firstNAME, rownumber() OVER (ORDER BY firstNAME) AS rn FROM user) AS tr WHERE rn BETWEEN 11 and 20
Hope it helps...
p.nee “OLAP Functions in the SQL Reference” for fancy stuff like rownum and rank
Does not work on z/os
The query you suggested works on db2 on pc but not on db2 7.1.1 on z/os. any ideas?
sorry dude not into z/os but the following link may give u some insight
sorry to know that this link also ends in a dead end... If (only if) i do find somthing ' else i'll post it here.. check this thread in the next 24 hrs