Question d’entretien chez Citi
SQL: Difference between 'where' clause and 'having' clause?
Réponse à la question d'entretien
Utilisateur anonyme
17 févr. 2010
The difference between a "where" clause and a "having" clause is a "Where" clause is applied to enforce condition on select statement and a single row function and is applied prior to GROUP BY clause where as HAVING clause is applied to enforce condition of GROUP Function and is applied after GROUP BY clause in the inquiry.