sql 行转列，使用case when then

jiangyongyuan

于 2012-03-20 11:29:17 发布

阅读量340

点赞数

分类专栏： sql

本文链接：https://blog.youkuaiyun.com/jiangyongyuan/article/details/84171503

版权

sql 专栏收录该内容

1 篇文章

订阅专栏

行转列，使用case when then

		select
			date,
			sum(case c.type when 'try-pay' then c.sum else 0 end ) as 'try-pay',
			sum(case c.type when 'pay-real' then c.sum else 0 end )as 'pay-real',
			sum(case c.type when 'pay-success' then c.sum else 0 end )as 'pay-success',
			sum(case c.type when 'pay-failure' then c.sum else 0 end )as 'pay-failure',
			sum(case c.type when 'notify-input' then c.sum else 0 end )as 'notify-input',
			sum(case c.type when 'normal-query' then c.sum else 0 end )as 'normal-query'
			
		from
			(SELECT sum(f_count) as sum ,f_type as type ,f_date as date FROM t_log_analyse
			 group by f_type,f_date order by f_date desc) 
		as c
			
		group by date