oracle分页查询sql语句
oracle分页查询语句:
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM Tables) A WHERE ROWNUM <= 10 ) WHERE RN > 0
正在加载评论...
oracle分页查询语句:
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM Tables) A WHERE ROWNUM <= 10 ) WHERE RN > 0