Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: WHERE vs. GROUP BY again

    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...

  • RE: WHERE vs. GROUP BY again

    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) >...

Viewing 2 posts - 1 through 2 (of 2 total)