mysql 使用union，使结果合并

cainiaoxiaoli

于 2020-11-09 17:09:01 发布

阅读量511

点赞数

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

本文链接：https://blog.youkuaiyun.com/cainiaoxiaoli/article/details/109581524

版权

union 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个复杂的SQL查询案例，用于从数据库表'ky_thesis'中按单位统计2020年度审核通过的数据记录数，区分不同的认领状态，并对结果进行汇总。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


SELECT name,SUM(value) FROM
(SELECT
	cliam_unit AS `name`,
	COUNT( id ) AS `value` 
FROM
	ky_thesis 
WHERE
	statistical_year = 2020 
	AND cliam_unit <> "" 
	AND STATUS = "审核通过" 
	AND claim_status != '不需认领' 
GROUP BY
cliam_unit 

UNION

SELECT
	unit AS `name`,
	COUNT( id ) AS `value` 
FROM
	ky_thesis 
WHERE
	statistical_year = 2020 
	AND unit <> "" 
	AND STATUS = "审核通过" 
	AND claim_status = '不需认领' 
GROUP BY
	unit) as thesis_all
	
	GROUP BY name