根据状态获取各个状态汇总,如下图
实现
select provice,
(select count(*) from [monitor] m where state=0 and m.provice=monitor.provice ) as m1,
(select count(*) from [monitor] m where state=1 and m.provice=monitor.provice) as m2,
(select count(*) from [monitor] m where state=2 and m.provice=monitor.provice) as m3,
(select count(*) from [monitor] m where state=3 and m.provice=monitor.provice) as m4
from [dbo].[monitor] group by provice