Zoomed Image

AMSX Scripting Language - Command : sqlstatement.havingclause

Summary

Add a HAVING clause to a SQL statement variable

Description

Appends a HAVING condition to the given SQL statement variable. Used after GroupBy to filter aggregated results.

Parameters

ParameterDescription
cmdSQL statement variable name
Argument 0HAVING condition (comma-separated field expressions)

Syntax


SqlStatement.HavingClause "SQL statement variable name", "HAVING condition (comma-separated field expressions)"

Return to the AMSX Command Reference