I've been coding for over 20 years now! (WOAH, do I feel old)
I've touched just about every resource imaginable under the Sun (too bad they were bought out by Oracle)
"HAVING is used on aggregate functions in lieu of the WHERE clause."
Not quite. You can have both HAVING and WHERE in the same SQL query, or either of the two for an aggregate query. The difference is that WHERE is applied before the aggregation, and HAVING is applied after.
"HAVING is used on aggregate functions in lieu of the WHERE clause."
Not quite. You can have both HAVING and WHERE in the same SQL query, or either of the two for an aggregate query. The difference is that WHERE is applied before the aggregation, and HAVING is applied after.
Thanks for clarifying!