select a.unit,b.sum from (select unit from user where level = 3 ) a ,(select count(*) as sum from user where level = 3 ) b
...
你这绝对是没规律的硬性结果
select unit,count(1)
from user a cross apply (select count(1)
from user
group by [level]) b
where a.[level]=3
group by unit
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024