舍瓦罗尼

摘要： 一、查询前几条记录：Select 列名1…列名n from （select 列名1..列名n from 表名 order by 列名1..列名n） where rownum<=N order by rownum asc;二、在TOP N记录中抽出第M（M<=N）条记录Select 列名1…列名n from ( select rownum recno, 列名1…列名n from (select 列名1…列名n from 表名 order by 列名1…列名n) where rownum <=N ORDER BY ROWNUM ASC) where recno = M (M< 阅读全文