oracle分页

时间：2016-07-24 20:46:53 阅读：204 评论：0 收藏：0 [点我收藏+]

SELECT * FROM 
(
SELECT A.*, ROWNUM RN 
FROM (SELECT * FROM TABLE_NAME) A 
)
WHERE RN BETWEEN 21 AND 40

SELECT *

FROM (SELECT a.*, ROWNUM rn

FROM (SELECT *

FROM table_name) a

WHERE ROWNUM <= 40)

WHERE rn >= 21

select first_name,rn from
　　　　(select a.*, ROWNUM rn from s_emp a where ROWNUM<=10)
where rn>5;

原文：http://www.cnblogs.com/hzzhero/p/5701458.html

踩

(0)

评论一句话评论（0）

分享档案

更多>