Orcal:
1)前N条:
select 列名1 ...列名n from
(
select 列名1 ...列名n
from 表名 order by 列名1 desc
)
where rownum <=N(抽出记录数);
如:select id,name from (select id,name from student order by name desc) where rownum<=10 ;
按姓名降序取出前十条数据
2)从第N条到第N条: