34,575
社区成员
发帖
与我相关
我的任务
分享
select
top 10 [故障设备] ,count(1) as [次数]
from
tb
group by
[故障设备]
order by
count(1) desc
select top 10 故障设备 ,count(*) 次数
from tb
group by 故障设备
order by count(*) desc
select top 10 [故障设备] ,count(*) as [次数]
from tb
group by [故障设备]
order by count(*) desc
select top 10 故障设备 ,count(*) 次数
from tb
group by 故障设备
order by count(*) desc
select 故障设备,count(*) AS 频率 INTO #T FROM TB GROUP group by 故障设备
SELECT TOP 10 * FROM #T ORDER BY 频率 DESC
select top 10 故障设备
from tb
group by 故障设备
order by count(1) desc