将表列内容横向展示

表结构：

转化结果：

sql实现：

SELECT
	t.student AS '姓名',
	max(
		CASE
		WHEN course_name = '语文' THEN
			'分数'
		ELSE
			0
		END
	) AS '语文',
	max(
		CASE
		WHEN course_name = '数学' THEN
			'分数'
		ELSE
			0
		END
	) AS '数学',
	max(
		CASE
		WHEN course_name = '物理 ' THEN
			'分数'
		ELSE
			0
		END
	) AS '物理 ',
	cast(avg(t.score) as decimal(18,2)) AS '平均分',
	sum(t.score) AS '总分'
FROM
	course t
GROUP BY
	t.student

转载自： 简书 - 低至一折起

文章：www.jianshu.com/p/9af4e43ed…