case when最正规写法实现行专列
select * from wyc_test
select a.date,
sum(case a.name when '小说' then a.scount else 0 end) 'sum_小说',
max(case a.name when '小说' then a.scount else 0 end) 'max_小说',
sum(case a.name when '微信' then a.scount else 0 end) '微信',
max(case a.name w
原创
2021-12-29 11:00:22 ·
212 阅读 ·
0 评论