AdobeStock_455007340

Grouping Output Data

The GROUP attribute is used to group database output so that rows may be grouped as needed. To use this attribute correctly your database query must be sorted properly using the same sort sequence as the one used for grouping. And be sure to use the SQL ORDER BY clause (although it is named GROUP BY, the GROUP BY attribute does not sort data for output grouping). (Applies to: ColdFusion All)

Leave a Reply