select m.name,m.numbs from (select name,count(name) as numbs from kh_hbrc_info t
where t.tpr_fl='软件技术' and t.xzzhw='软件部'group by name
order by numbs desc) m where rownum<=3;
select m.name,m.numbs from (select name,count(name) as numbs from kh_hbrc_info t
where t.tpr_fl='软件技术' and t.xzzhw='软件部'group by name
order by numbs desc) m where rownum<=3;