db2 rownumselect id from(select ROW_NUMBER() OVER() AS a,idfrom tab)where a 0 and a50
db2 "rownum"
select id from(
select ROW_NUMBER() OVER() AS a,id
from tab
)
where a > 0 and a<50
db2 "rownum"
select id from(
select ROW_NUMBER() OVER() AS a,id
from tab
)
where a > 0 and a<50