论坛 › DB2 › db2　分页查询

tset123 发表于 2016-11-14 06:11:33

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

查看完整版本: db2　分页查询