Bookspan interview question

Difference between Where and Having in sql?

Interview Answer

Anonymous

5 Mar 2015

Both filters out records based on one or more conditions. The diff is "where" can only be applied on static non aggregated column whereas having is for aggregated columns.