Re: [HACKERS] We are not following the spec for HAVING without GR

[Bort, Paul]

Title: RE: [HACKERS] We are not following the spec for HAVING without GROUP BY

> Would those of you with access to other DBMSes try this:

<snip>

Results for "Microsoft SQL Server  2000 - 8.00.944 (Intel X86)":

           
-----------

(0 row(s) affected)

           
-----------
1

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

           
-----------

(0 row(s) affected)

           
-----------
1

(1 row(s) affected)

So it looks like MS is following the standard.