Question

mysql查询某列中数据出现次数最多的数据

原数据
id name
1 a
1 a
1 b
2 a
2 b
2 b
查询结果：
id name
1 a
2 b
拜托了！

Answer 1

select a.id,a.sname 

from 

(

select id,sname,count(sname) num from muchc group by id,sname

) a,

(

select max(num) num

from

(

select id,sname,count(sname) num from muchc group by id,sname

)b

GROUP BY id) b

where a.num=b.num

GROUP BY id

Answer 2

select count(*) number from 表名 group by name order by number desc