MySQL - Utilisation de COUNT(*) dans la clause WHERE

Question

J'essaie d'accomplir ce qui suit dans MySQL (cf. pseudo code)

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

Existe-t-il un moyen de faire cela sans utiliser un (SELECT...) dans la clause WHERE, car cela semble être un gaspillage de ressources.

Toute aide est appréciée.

Gracias.

Answer 1

Essayez ceci ;

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

Answer 2

Je ne suis pas sûr de ce que vous essayez de faire... peut-être quelque chose comme

SELECT gid, COUNT(*) AS num FROM gd GROUP BY gid HAVING num > 10 ORDER BY lastupdated DESC

Answer 3

SELECT COUNT(*)
FROM `gd`
GROUP BY gid
HAVING COUNT(gid) > 10
ORDER BY lastupdated DESC;

EDIT (si vous voulez juste les gids) :

SELECT MIN(gid)
FROM `gd`
GROUP BY gid
HAVING COUNT(gid) > 10
ORDER BY lastupdated DESC

Answer 4

Juste la version académique sans avoir de clause :

select *
from (
   select gid, count(*) as tmpcount from gd group by gid
) as tmp
where tmpcount > 10;

Answer 5

Essayez

SELECT DISTINCT gid
FROM `gd`
group by gid
having count(*) > 10
ORDER BY max(lastupdated) DESC