Difference between where and having in SQL Server
For database related videos, please subscribe channel
/ @datagurunaval
WHERE clause cannot be used with aggregates, but the HAVING clause can.
Where clause filters rows before aggregate calculations are performed where as
Having clause filters rows after aggregate calculations are performed.
so from performance standpoint, HAVING is slower than WHERE and should be avoided when possible
