如何查询数据库里某个字段的某个值出现频率最高的那一个

[awjx]

如何查询数据库里某个字段的某个值出现频率最高的那一个?
如:
日期 故障设备
3.01 a
3.02 b
3.03 c
3.04 a
3.05 c
3.06 a
3.07 d

找出“故障设备”字段中出现最多的那个值。

[WWWWA]

select * from (
select 故障设备,count(*) as ma from tth1 group by 故障设备) where ma=(select max(ma) from (select 故障设备,count(*) as ma from tth1 group by 故障设备))

[ACMAIN_CHM]

select top 1 * from (
select 故障设备,count(*) from table1 group by 故障设备
)
order by 2 desc

[rucypli]

select top 1 故障设备
from (
select 故障设备,count(*) as num from tb group by 故障设备
)T
order by T.num desc

[加油馒头]

select 故障设备,max(c) from (
select 故障设备,count(*) c from table1 group by 故障设备
)
order by 2 desc

[加油馒头]

select 故障设备,max(c) from (
select 故障设备,count(*) c from table1 group by 故障设备
)

[xc_aspnet]

思路就是 按 故障设备 分组 统计个数

[wwwwb]

select top 1 * from (
select 故障设备,count(*) as ma from tth1 group by 故障设备) order by ma desc