一.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;