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