Re: Query Conflict

There was a discussion of this on m.p.sqlserver.programming only a few
days ago on the 24th, Question regarding "HAVING COUNT(*)=0".

What I got out of it was that using an aggregate function without a
GROUP BY clause means there is just one single group. Thus, HAVING is
appropriate.



On Sat, 29 Sep 2007 16:54:38 -0500, "David W. Fenton"
<XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote:

I still don't get why you need a HQAVING because you have no GROUP
BY clause.
.

Quantcast