sql - 如何在 SQL 中不显示计数列

Question

这是我的查询:

SELECT  ID ,
        COUNT(STATUS)
FROM    tablename
WHERE   STATUS = 'GREEN'
GROUP BY ID
HAVING  COUNT(STATUS) > 3;

我需要结果只显示 ID 列，而不显示每行的计数。

Answer 1

只需将其从选择列表中删除:

select   ID -- count(STATUS) removed here
from     TABLENAME
where    STATUS = 'GREEN' 
group by ID
having   count(STATUS) > 3