DB2中如何实现分页

select * from
(select customer_id,customer_date,customer_result,rownumber()over(order by customer_id asc) as id from customer_djxx )
as tb
where tb.id between 10 and 20

 

between and 前后两者都包含。即记录是从排序好的记录中选出10到20这11条记录

若不想让你包括后者或者前者可采取下面这种办法

select * from (
select customer_id,customer_date,customer_result,rownumber() over(order by customer_id asc ) as rowid  from customer_djxx )
as a where a.rowid >= 10 AND  a.rowid < 20