Oracle查询前100万条数据
Oracle不支持select top语句，在Oracle中经常是用order by跟rownumselect 列名1 ...列名n from(select 列名1 ...列名n from 表名 order by 列名1)where rownum <=N(抽出记录数)order by rownum asc如：按姓名排序取出前十条数据select id,name from (select...
