Microsoft KB Archive/89826

= PRB: Documentation for GROUP BY Clause Is Incorrect =

Article ID: 89826

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q89826



SYMPTOMS
Page 232 of the Microsoft SQL Server version 4.2 &quot;Language Reference&quot; incorrectly states the following:

A table can be grouped by any combination of columns--that is, groups can be nested within each other. Note that you cannot group by a column heading; you must use a column name, an expression, or a number representing the position of the item in the select list.

This statement is incorrect when it says that a number can be used in the GROUP BY clause to represent the field in the select list. A number can be used only in an ORDER BY clause, not a GROUP BY.

Additional query words: Transact-SQL Lang Ref documentation error Windows NT

Keywords: kbother KB89826

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.