表示順n〜m件までのレコードを取得。 select * from (select T.*,rownum as RM from (select * from TABLE_NAME order by hoge) T) where RM between n and m;