sql 查询

根据状态获取各个状态汇总，如下图

实现

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

posted on 2014-02-26 00:55 tomfang 阅读(165) 评论(0) 编辑收藏举报