MySql行转列统计

方法一:

1 select request_date,user_name,
2   max(case code when '成功' then count else 0 end) 成功数,
3   max(case code when '失败' then count else 0 end) 失败数
4 from (select user_name,request_date,code,count(*) count
5      from TEST_TB_GRADE
6      group by user_name,request_date,code) src
7 group by request_date,user_name
8 order by request_date,user_name;

方法二：

1 select request_date,user_name,
2   sum(case code when '成功' then 1 else 0 end) 成功数,
3   sum(case code when '失败' then 1 else 0 end) 失败数,
4   count(*) 总数
5 from TEST_TB_GRADE
6 group by request_date,user_name;

 

转载于:https://www.cnblogs.com/jason123/p/7699354.html