select PC状态,count(distinct PC个数) PC个数 from 表 group by PC状态
select PC状态,count(distinct PC) as PC个
from table
group by PC状态
select PC状态,count(*) as 'PC个数'
from (select distinct PC状态 ,PC from 你的表) tmp
group by PC状态
SELECT PC状态,COUNT(*) FROM
(
SELECT DISTINCT (PC状态),PC FROM 表
)
group by PC状态
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024