sql聚合函数使用-笔记

最新推荐文章于 2024-06-15 20:21:51 发布

星月前端

最新推荐文章于 2024-06-15 20:21:51 发布

阅读量273

点赞数 3

文章标签： sql 笔记数据库

本文链接：https://blog.csdn.net/qq_61950936/article/details/139152619

版权

sql聚合函数使用-笔记

在这里插入图片描述

SELECT SUM ( case when procurement_type = '公益推送' then 1 else 0 end ) gywxTotal,
	SUM ( CASE WHEN (status = 1 and procurement_type = '公益推送') THEN 1 ELSE 0 END ) gywxYsc,
	SUM ( CASE WHEN (status != 1 and procurement_type = '公益推送') THEN 1  ELSE 0 END ) gywxWsc,
	SUM ( case when procurement_type = '商业采购' then 1 else 0 end ) sywxTotal,
	SUM ( CASE WHEN (status = 1 and procurement_type = '商业采购') THEN 1 ELSE 0 END ) sywxWsc,
	SUM ( CASE WHEN (status != 1 and procurement_type = '商业采购') THEN 1  ELSE 0 END ) sywxYsc 
FROM
	st_2k_image_org_s 
WHERE
	image_type = 1 
	and year = '2023'