SQL HAVING. Clauza SQL HAVING. Sintaxa HAVING.

Clauza SQL HAVING

Clauza HAVING a fost adăugată la SQL, deoarece cuvântul cheie WHERE nu a putut fi utilizat cu funcții de agregare.

Sintaxa HAVING
 

SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
HAVING condition
ORDER BY column_name(s);