16.20 - GROUP BY Affects Report Breaks - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

VAR_SAMP operates differently depending on whether or not there is a GROUP BY clause in the SELECT statement.

IF the query … THEN VAR_SAMP is reported for …
specifies a GROUP BY clause each individual group.
does not specify a GROUP BY clause all the rows in the sample.