oracle简单查询之分页查询

oracle简单查询之分页查询

《PS：留下小赞赞，比心比心》

--oracle简单查询之分页查询
	格式1(推荐)
	
	SELECT * FROM   
	(  
	SELECT temp.*, ROWNUM RN   
	FROM (SELECT * FROM 表名) temp  
	WHERE ROWNUM <=end (page*pagesize)  
	)  
	WHERE RN >=start (page-1*pagesize+1)
	
	格式2
	
	SELECT * FROM   
	(  
	SELECT temp.*, ROWNUM RN   
	FROM (SELECT * FROM TABLE_NAME) temp   
	)  
	WHERE RN BETWEEN start (page-1*pagesize+1) AND end (page*pagesize)
	参考地址：
	https://www.imooc.com/article/19758
	https://www.cnblogs.com/wangyong/p/3396333.html