在数据表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;