PRB: Documentation for GROUP BY Clause Is Incorrect

ID: Q89826


The information in this article applies to:
  • Microsoft SQL Server for OS/2, version 4.2
  • Microsoft SQL Server version 4.2x


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
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.