Pregunta de entrevista de Citi
SQL: Difference between 'where' clause and 'having' clause?
Respuesta de la entrevista
Anónimo
17 de feb de 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.