What is the difference between having and where clause in Mysql? Explain
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.
BY Best Interview Question ON 27 Jan 2019