count 中使用if语句

最新推荐文章于 2024-06-26 21:56:48 发布

自转的轮子

最新推荐文章于 2024-06-26 21:56:48 发布

阅读量788

点赞数

分类专栏： java 文章标签： mysql

本文链接：https://blog.csdn.net/qq_27818157/article/details/106638430

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

SELECT b.tax_pch,COUNT(IF(b.tax_status IN(0,1,2),TRUE ,NULL))AS '总人数',
		 COUNT(IF(b.tax_status IN (0,1),TRUE ,NULL))AS '未报人数',
		 COUNT(IF(b.tax_status = 2,TRUE ,NULL))AS '已报人数',
	b.tax_model,b.tax_company,
	         SUM(IF(b.tax_status IN(0,1,2),tax_pay ,0) ) AS '应报税金额总计',
		 SUM(IF(b.tax_status IN(0,1),tax_pay ,0) ) AS '已报税金额',
		 SUM(IF(b.tax_status =2,tax_pay ,0) ) AS '未报税金额'
	FROM tax_bill b  WHERE 1=1 GROUP BY tax_pch