SQL 转换行列例题

最新推荐文章于 2024-07-07 11:33:44 发布

雪梨不加冰糖

最新推荐文章于 2024-07-07 11:33:44 发布

阅读量60

点赞数

文章标签： sql 数据库 mysql

本文链接：https://blog.csdn.net/qq_38868439/article/details/132622972

版权

SQL 转换行列例题

在这里插入图片描述

/* 转换行列——在表头里加入汇总和再揭(p.287) */
SELECT
	CASE
		SEX WHEN '1' THEN '男'
		ELSE '女'
	END AS '性别',
	SUM(POPULATION) AS '全国',
	SUM(CASE WHEN pref_name = '德岛' THEN population ELSE 0 END) AS '德岛',
	SUM(CASE WHEN pref_name = '香川' THEN population ELSE 0 END) AS '香川',
	SUM(CASE WHEN pref_name = '爱媛' THEN population ELSE 0 END) AS '爱媛',
	SUM(CASE WHEN pref_name = '高知' THEN population ELSE 0 END) AS '高知',
	SUM(CASE WHEN pref_name IN ('德岛', '香川', '爱媛', '高知')
                THEN population ELSE 0 END) AS '再揭'
FROM
	POPTBL2 P
GROUP BY
	SEX