-
mySql关于统计数量的SQL查询 *** 作
我就废话不多说了,大家还是直接看代码吧~select project_no,sum(case when device_state=0 then 1 else 0 end)as offTotal ,sum(case when device
我就废话不多说了,大家还是直接看代码吧~select project_no,sum(case when device_state=0 then 1 else 0 end)as offTotal ,sum(case when device