oracle 和MySQL 按行查询

oracle 用where rownum

查询前6条数据
select * from test where rownum<= 6 ;

结合升降序
select * from(select * from test order by id desc) where rownum<= 6 ; #表示按id降序后取前6行
select * from test where rownum<= 6 order by id desc ;  #表示取前6行后再按id降序

mysql 用limit

查询前6条数据
select * from test limit 6;

按id 升序后查看前6条数据
select * from test order by id asc limit 6;

limit x,y
select * from test order by id asc limit 5,10 ;  #表示从第5行开始再取10条数据（6.7.8.9.10行数据）