mysql行转列例子

最新推荐文章于 2022-06-10 11:45:44 发布

wangxp

最新推荐文章于 2022-06-10 11:45:44 发布

阅读量229

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/wangxp/article/details/86981620

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

select
	project_name,
	sum(case when work_type = '研发' then sum_type else 0 end) yanfa,
	sum(case when work_type = '服务' then sum_type else 0 end) fuwu,
	sum(case when work_type = '实施' then sum_type else 0 end) shishi,
	sum(case when work_type = '售前' then sum_type else 0 end) shouqian
from
	(
	select
		project_name,
		work_type,
		sum(days) as sum_type
	from
		ebmp.project_workload
	group by
		project_name) as t
group by
	project_name