What is the difference between HAVING and WHERE clauses? Explain with the help of an example.
WHERE Vs HAVING: WHERE is used to put a condition on individual row of a table whereas HAVING is used to put condition on individual group formed by GROUP BY clause in a SELECT statement.