Thread: Re: We are not following the spec for HAVING without GR

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

From
"Bort, Paul"
Date:
<p><font size="2">> Would those of you with access to other DBMSes try this:</font><p><font
size="2"><snip></font><br/><p><font size="2">Results for "Microsoft SQL Server  2000 - 8.00.944 (Intel
X86)":</font><p><fontsize="2">            </font><br /><font size="2">----------- </font><p><font size="2">(0 row(s)
affected)</font><p><fontsize="2">            </font><br /><font size="2">----------- </font><br /><font
size="2">1</font><p><fontsize="2">(1 row(s) affected)</font><br /><p><font size="2">(1 row(s) affected)</font><br
/><p><fontsize="2">(1 row(s) affected)</font><p><font size="2">            </font><br /><font size="2">-----------
</font><p><fontsize="2">(0 row(s) affected)</font><p><font size="2">            </font><br /><font size="2">-----------
</font><br/><font size="2">1</font><p><font size="2">(1 row(s) affected)</font><p><font size="2">So it looks like MS is
followingthe standard.</font>