AMSX Scripting Language - Command : SqlStatement.ClearGroupBy

Summary

Remove the GROUP BY clause from a SQL statement variable

Description

Clears the GROUP BY clause from the given SQL statement variable. Use this before rebuilding the group-by with GenerateGroupByClause or when switching from an aggregated to a detail query.

Parameters

Parameter	Description
cmd	SQL statement variable name

Syntax


SqlStatement.ClearGroupBy "SQL statement variable name"

Return to the AMSX Command Reference