SELECT * FROM ( SELECT A.*, ROWNUM RN FROM ( 原sql ) A WHERE ROWNUM <= 40 ) WHERE RN > 30
orcale sql分页
最新推荐文章于 2024-07-23 19:39:30 发布
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM ( 原sql ) A WHERE ROWNUM <= 40 ) WHERE RN > 30