oracle分页查询sql语句

oracle分页查询语句:

SELECT * FROM 
(
SELECT A.*, ROWNUM RN  FROM (SELECT * FROM Tables) A  WHERE ROWNUM <= 10
)
WHERE RN > 0

 

正在加载评论...