Oracle之分页查询
select * from ( select a.*, rownum rn from (select * from table_name) a where rownum<= 40 ) where rn >= 21
清醒时做事,糊涂时读书,大怒时睡觉,独处时思考;做一个幸福的人,读书,旅行,努力工作,关心身体和心情,成为最好的自己
select * from ( select a.*, rownum rn from (select * from table_name) a where rownum<= 40 ) where rn >= 21