GROUP BY Predicate
Topic Last Modified: 2006-06-13
The Structured Query Language (SQL) GROUP BY predicate organizes the returned recordset according to one or more of the properties specified in the SQL SELECT Statement.
GROUP BY "propertyName" [,"propertyName"] [,"propertyName"]
The parameter propertyName specifies properties selected in your SQL query that you want to group.
Remarks
If you include the visiblecount Field in the SELECT Statement, a count of the occurrences of matching items, as specified by GROUP BY, will be created.
GROUP BY is not supported on Multi-Value properties.