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