PRB: Documentation for GROUP BY Clause Is Incorrect (89826)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q89826 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.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbother KB89826 |
|---|
|