Difference between WHERE vs HAVING in SQL

1) WHERE clause is processed right after FROM clause in the logical order of query processing, which means it is processed before GROUP BY clause while HAVING clause is executed after groups are created. 2) If used in GROUP BY, You can refer any column from a table in WHERE clause but you can only […]