Progress
SQL-92
Guide and Reference
GROUP BY CLAUSE
Specifies grouping of rows in the result table.
SYNTAX
NOTES
- For the first column specified in the
GROUP
BY
clause, SQL arranges rows of the result table into groups whose rows all have the same values for the specified column.- If you specify a second
GROUP
BY
column, SQL groups rows in each main group by values of the second column.- SQL groups rows for values in additional
GROUP
BY
columns in a similar fashion.- All columns named in the
GROUP
BY
clause must also be in the select list of the query expression. Conversely, columns in the select list must also be in theGROUP
BY
clause or be part of an aggregate function.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |