这里写自定义目录标题 oracle 求一组数据中 出现最多次数的数值 select name from (select name,count(1) as num from table1 group by name order by num desc) where rownum=1;