DB2 分页sql:
select * from (
select field1, field2, field3, row number()
over( order by id asc) as rn
from table) as a1
where a1.rn between 10 and 20
select * from (
select field1, field2, field3, row number()
over( order by id asc) as rn
from table) as a1
where a1.rn between 10 and 20