HAVING

Filtre les groupes après un GROUP BY (WHERE filtre les lignes avant).

Syntaxe

SELECT colonne, COUNT(*) FROM table GROUP BY colonne HAVING condition;

Exemple

SELECT ville, COUNT(*) FROM clients GROUP BY ville HAVING COUNT(*) > 10;

← Tout le glossaire des commandes