oracle和mysql,取前N条记录

一.oracle

  1.select * from trequest_net tr where rownum<=N;

  2.select vc_fundacco from (select tr.vc_fundacco,rownum rn from trequest_net tr where rownum<=N) ;

  3.select vc_fundacco from (select tr.vc_fundacco,row_number() over (order by vc_fundacco) rn from trequest_net tr) where rn<=N;

 

二.mysql

  select * from trequest_net tr order by vc_fundacco desc limit 0,N;