MIN and MAX functions are supported.

MIN and MAX functions are supported.

• A. True
• B. False
• C. Not specified
• D. Depends

Answer: (A)

MIN and MAX are standard aggregate functions used to find the smallest and largest values in a set of rows. In Marketing Cloud’s SQL-like query language, these functions are supported and can be used in a SELECT clause to derive extremes across data. They work with numeric, date/time, and even string values (where strings follow the database’s collation rules). NULL values are ignored by these aggregates, so only non-null values contribute to the result. You can apply them across the entire dataset or within groups using GROUP BY to get per-group minima and maxima. For example, SELECT MIN(Amount) AS MinAmount, MAX(Amount) AS MaxAmount FROM Transactions shows the overall bounds, while SELECT CustomerID, MIN(Amount) AS MinAmount, MAX(Amount) AS MaxAmount FROM Transactions GROUP BY CustomerID shows per-customer extremes. This confirms the statement is correct.

MIN and MAX are standard aggregate functions used to find the smallest and largest values in a set of rows. In Marketing Cloud’s SQL-like query language, these functions are supported and can be used in a SELECT clause to derive extremes across data. They work with numeric, date/time, and even string values (where strings follow the database’s collation rules). NULL values are ignored by these aggregates, so only non-null values contribute to the result. You can apply them across the entire dataset or within groups using GROUP BY to get per-group minima and maxima. For example, SELECT MIN(Amount) AS MinAmount, MAX(Amount) AS MaxAmount FROM Transactions shows the overall bounds, while SELECT CustomerID, MIN(Amount) AS MinAmount, MAX(Amount) AS MaxAmount FROM Transactions GROUP BY CustomerID shows per-customer extremes. This confirms the statement is correct.