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

Parameter	Description
cmd	SQL statement variable name

Syntax


SqlStatement.GenerateGroupByClause "SQL statement variable name"

Return to the AMSX Command Reference