What is the difference between having and where clause in Mysql? Expla

1.	What is the difference between having and where clause in Mysql? Explain
Answer» WHERE term is USED for FILTERING ROWS, and it APPLIES to every row but HAVING term is used to filter groups. WHERE can be used without the GROUP BY but HAVING clause cannot be used without the GROUP BY.

What is the difference between having and where clause in Mysql? Explain

Answer»

WHERE term is USED for FILTERING ROWS, and it APPLIES to every row but HAVING term is used to filter groups.

WHERE can be used without the GROUP BY but HAVING clause cannot be used without the GROUP BY.