在数据表A中有BCDE四个字段共1000条记要，要求以C排序，查询第890行到930行的记录的SQL

在数据表A中有BCDE四个字段共1000条记录，要求以C排序，查询第890行到930行的记录的SQL
在数据表A中有BCDE四个字段共1000条记录，要求以C排序，查询第890行到930行的记录的SQL语句
--第一种方法：消耗资源最多
select *
  from (select rownum rnm, aa.* from (select * from A order by c) aa)
where rnm between 890 and 930;
--第二种方法：消耗资源较少
select *
  from (select rownum rnm, aa.*
          from (select * from A order by c) aa
         where rownum <= 930)
where rnm >= 890;
--第三种方法：消耗资源最少
select *
  from A
where rowid in (select rid
                   from (select rownum rno, rowid rid
                           from (select * from A order by C)
                          where rownum <= 930)
                  where rno >= 890)
order by C;