资产清单数据库的SQL计数查询

我想你要：

Select [cube],
       sum(case when devicetype = 'monitor' then 1 else 0 end) as num_monitors,
       sum(case when devicetype = 'phone' then 1 else 0 end) as num_phones,
       sum(case when devicetype = 'desktop' then 1 else 0 end) as num_desktops
from sampledata
group by [cube]
having sum(case when devicetype = 'monitor' then 1 else 0 end)  <> 1 or
       sum(case when devicetype = 'phone' then 1 else 0 end) <> 1 or
       sum(case when devicetype = 'desktop' then 1 else 0 end) <> 2;

cube是列的较差名称，因为它是SQL Server保留字。那意味着它需要被逃脱。