摘要:
根据状态获取各个状态汇总,如下图实现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...
阅读全文
posted @ 2014-02-26 00:55
tomfang
阅读(168)
推荐(0)
编辑