db2 分页查询

SELECT * FROM "ACT" a1 where (select count(*) from act a2 where a2.actno<a1.actno )>4 and (select count(*) from act a2 where a2.actno<a1.actno)<10

 查询５条。。

 

查询前10条数据

 

 

select * from act fetch first 10 rows only