Posted By: ColinYounger
What is the difference between
WHERE in an
SQL SELECT statement?
EDIT: I have marked Steven’s answer as the correct one as it contained the key bit of information on the link:
GROUP BYis not used,
HAVINGbehaves like a
The situation I had seen the
WHERE in did not have
GROUP BY and is where my confusion started. Of course, until you know this you can’t specify it in the question.
HAVING specifies a search condition for a
group or an aggregate function used in SELECT statement.