Oracle rownum

1.rownum的数据是从1开始生成的

2.MySQL limit 等价于 Oracle rownum

MySQL :select * from table_name limit n;
Oracle: select * from table_name where rownum < n;

select * from table_name where rownum < n;

4 output m-n data records

select * from (select rownum rn,t.* from tbale_name t where rownum<=n) t 
where t.rn >=m;

5 Why not ouput data records?

select * from table_name where rownum > 2;

6 why output only two records?

select * from table_name where rownum != 3;