DB2分页查询简单示例
select * from ( select a.* ,rownumber() over(order by create_time desc) as rowid from ( select * from vip_recognition_recode) a) tmp where tmp.rowid <= 10 and tmp.rowid >=1
select * from ( select a.* ,rownumber() over(order by create_time desc) as rowid from ( select * from vip_recognition_recode) a) tmp where tmp.rowid <= 10 and tmp.rowid >=1