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) as decrypt FROM File f
转载于:https://www.cnblogs.com/niuxi/p/6743714.html
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) as decrypt FROM File f
转载于:https://www.cnblogs.com/niuxi/p/6743714.html