摘要： 根据状态获取各个状态汇总，如下图实现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,(sel... 阅读全文