mysql group by 计数_MySQL-带GROUP BY的条件计数

最新推荐文章于 2024-03-25 13:48:17 发布

DreamBSD

最新推荐文章于 2024-03-25 13:48:17 发布

阅读量699

点赞数

文章标签： mysql group by 计数

本文链接：https://blog.csdn.net/weixin_42509548/article/details/113233456

版权

在MySQL中，作者遇到一个问题，需要在GROUP BY查询中只计算`droid_v`大于0的值。尝试了不同的SQL语句，最终找到解决方案：使用CASE WHEN语句结合COUNT(DISTINCT)来有条件地计数。正确查询应为：`SELECT puid, COUNT(DISTINCT CASE WHEN droid_v > 0 THEN droid_v END) AS droid, COUNT(DISTINCT sig_v) AS sig, SUM(NoExt) AS hits FROM temp GROUP BY puid`。" 40826103,4878285,Android通过JDBC连接SQL Server 2008实现数据库操作,"['Android开发', '数据库连接', 'JDBC驱动', 'SQL Server']

摘要由CSDN通过智能技术生成

I'm trying to refine a query that I am currently using:

SELECT `puid`,

COUNT(DISTINCT `droid_v`) AS DROID,

COUNT(DISTINCT `sig_v`) AS sig,

SUM(NoExt) AS hits

FROM temp

GROUP BY `puid`

And I need to get it to only count droid_v where droid_V is greater than 0. Is it possible to condition the count in this way? At the moment, it is counting zero values as countable, and I can't really change the zeros to null values.

I do not need to know the count value for droid_V = 0, I only need to count it if it has a number greater than 0. That number will always be either 0, 1, 2, 3, or 4.

I have tried:

SELECT `puid`,

COUNT(DISTINCT CASE WHEN `droid_v`