查询names字段出现次数最多的一个
sql语句
select names,count(1) as number from ceshi GROUP BY names ORDER BY count(1) desc limit 1
查询names字段出现次数最多的一个
sql语句
select names,count(1) as number from ceshi GROUP BY names ORDER BY count(1) desc limit 1