PRB: Documentation for GROUP BY Clause Is Incorrect

ID: Q89826

The information in this article applies to:

SYMPTOMS

Page 232 of the Microsoft SQL Server version 4.2 "Language Reference" 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 SSrvDoc_Err SSrvWinNT 
Version           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 13, 1999