用sql语句查询一列名中的各个数值的个数
摘要:SELECT COUNT(case when f.fileState=2 then 0 end) as fixed,COUNT(case when f.fileState=3 then 0 end) as Issue,COUNT(case when f.fileState=5 then 0 end)
阅读全文
posted @ 2017-04-21 15:10
posted @ 2017-04-21 15:10
posted @ 2017-04-21 15:07
posted @ 2017-04-21 12:04