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
查询5条。。
查询前10条数据
select * from act fetch first 10 rows only
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
查询5条。。
查询前10条数据
select * from act fetch first 10 rows only