- 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
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条。。
添加新评论0 条评论