sql统计篇 分类统计

 

SELECT SUM(CASE WHEN PcIncludedStatus=1 OR PcSubIncludedStatus=1 THEN 1 ELSE 0 END) AS PcIncludedCounts,
SUM(CASE WHEN PcIncludedStatus=0 AND PcSubIncludedStatus=0 THEN 1 ELSE 0 END) AS PcCounts,
SUM(CASE WHEN MIncludedStatus=1 OR MipIncludedStatus=1 THEN 1 ELSE 0 END) AS MIncludedCounts,
SUM(CASE WHEN MIncludedStatus=0 AND MipIncludedStatus=0 THEN 1 ELSE 0 END) AS MCounts
FROM dbo.t_BaiduIncludedTrade
WHERE CompanyId=1