AMSX Scripting Language - Command : SqlStatement.GenerateGroupByClause

Summary

Derive a GROUP BY clause automatically from the SELECT field list

Description

Generates a GROUP BY clause for the SQL statement variable by enumerating every field currently in the SELECT list. Call this after SetFields to produce an aggregation-ready query without manually listing the group-by columns.

Parameters

Syntax

SqlStatement.GenerateGroupByClause "SQL statement variable name"