Frage im Vorstellungsgespräch bei Citi
SQL: Difference between 'where' clause and 'having' clause?
Antwort im Vorstellungsgespräch
Anonym
17. Feb. 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.