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;
