读取M到N条记录

来源:互联网 发布:数据记录表 编辑:程序博客网 时间:2024/04/30 20:04

Orcle:

          select * from (select rownum as b,a.* from tableName a where rownum >= n) where b>=m

sql:

      select  top m  *  from (select top n * from table order by co1 asc) order by co1 desc