sql 行转列，使用case when then

 

行转列，使用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