Question d’entretien chez Lyra Health

When do you use WHERE vs HAVING in SQL?

Réponse à la question d'entretien

Utilisateur anonyme

18 août 2024

WHERE is used when filtering an overall table regularly, while HAVING is used when there are functions such as aggregates used and we need to filter on the results achieved after the aggregation