Case When 配合 SUM以及COUNT方法的使用
1.SUM中:
SUM(CASE phoneType WHEN 'iOS' THEN status ELSE 0 END) AS iOSClick,
SUM(CASE phoneType WHEN 'WeChat' THEN status ELSE 0 END) AS weChatClick,
SUM(CASE phoneType WHEN 'Andro...
原创
2019-10-29 11:56:48 ·
1488 阅读 ·
0 评论