Case When 配合 SUM以及COUNT方法的使用

最新推荐文章于 2024-06-19 21:26:16 发布

gs51955

最新推荐文章于 2024-06-19 21:26:16 发布

阅读量1.5k

点赞数

分类专栏： Mysql 文章标签： Mysql Case

本文链接：https://blog.csdn.net/gs51955/article/details/102796987

版权

Mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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 'Android' THEN status ELSE 0 END) AS androidClick

2.COUNT中:

        COUNT(DISTINCT CASE phoneType WHEN 'iOS' THEN id END) AS iOSPush,
        COUNT(DISTINCT CASE phoneType WHEN 'WeChat' THEN id END) AS weChatPush,
        COUNT(DISTINCT CASE phoneType WHEN 'Android' THEN id END) AS androidPush,