☰

MySQL - Using COUNT(*) in the WHERE clause Ask Question

tag-icon • tag-icon mysql count aggregation having
MySQL - Using COUNT(*) in the WHERE clause Ask Question

I am trying to accomplish the following in MySQL (see pseudo code)

SELECT DISTINCT gid
FROM `gd`
WHERE COUNT(*) > 10
ORDER BY lastupdated DESC

Is there a way to do this without using a (SELECT...) in the WHERE clause because that would seem like a waste of resources.

ベストアンサー1

try this;

select gid
from `gd`
group by gid 
having count(*) > 10
order by lastupdated desc

おすすめ記事