Oracle分页语句

　　page size :3　　page number: 2　　需要考虑order by 的情况：　　select s.* from　　(　　select rownum as rn,c.*　　from (select * from tableName order by columnName desc) c　　) s　　where s.rn between 3*(2-1)+1 and 2*3;　　select * from　　(