Viewing 2 posts - 1 through 2 (of 2 total)
Excluding the aggregates then yes your assertion is correct and would produce the same results.
But if I were an examiner in a test then I would say that by using...
January 28, 2013 at 8:40 am
#1581664
The condition in a HAVING clause is different than the condition on a WHERE clause as the HAVING condition acts on the result of the aggregation.
Consider the condition Count(something) >...
January 28, 2013 at 7:14 am
#1581614