SELECT COUNT(message_type) AS totalCount, SUM(CASE WHEN message_type = 1 THEN 1 ELSE 0 END) AS message_type1, SUM(CASE WHEN message_type = 2 THEN 1 ELSE 0 END) AS message_type2, SUM(CASE WHEN message_type = 3 THEN 1 ELSE 0 END) AS message_type3 FROM t_message //message_type1 多少个 message_type2多少个。。 //totalCount 为总计 //最后条件结尾不能有, 1.使用 GROUP BY 进行分类统计: SELECT message_type AS messageType,COUNT(id) AS totalFROM t_message WHERE receiver = 60GROUP BY message_type;
查询结果:左边值右边统计多少次
关注"都市百货" 了解南陵
微信咨询wanglf2r(不拉群 发广告者勿加)
热门评论