查询指定条数据的方法

Mysql与Oracle的区别

mysql

select * from table_name limit 5 offset 3

从第四条开始读5条数据

oracle

1. 使用rownum 虚列

select * from (
	select * from table_name
	order by column_name desc 
) where rownum <=5

读前五条数据

2. 最佳选择：利用分析函数

row_number() over ( partition by col1 order by col2 ) row_number() over
 ( partition by col1 order by col2 )  

例：

select * from (                               
     select *, row_number() over ( order by column_name) rn from table_name               
) where rn between 1 and 5;

读取一到第五条数据