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.

Example

Getting Item Counts with GROUP BY

See Also

Other Resources

SELECT Statement