Question

sql 怎么取count(*)中的最大值?

name
a
a
a
a
b
b
c
c
c
c
select count(name),name
from table
之後出现
name count()
a 4
b 2
c 4

而我其实只想找出出现最多次的name
即c和a
但又不能输入SQL为max(count(name))

我应该如何写这SQL..???

Answer 1

select name, count(name) from t group by name
having count(name)=
(select max(a.cou) from (select count(name) as cou from t group by name) a )

Answer 2

select top 1 name,count(name) from table group by name order by count(name) desc

Answer 3

可以试试max