16.20 - Traditional Aggregate Functions that Support Time Series - 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
You can use the following aggregate functions on time series data in PTI tables by using the GROUP BY TIME clause and in non-PTI tables by using the GROUP BY TIME clause with the USING TIMECODE option. For more information on these functions, see Teradata Vantage™ Time Series Tables and Operations, B035-1208.
  • AVERAGE
  • COUNT
  • KURTOSIS
  • MAXIMUM
  • MINIMUM
  • RANK (ANSI)
  • SKEW
  • STANDARD DEVIATION OF A POPULATION (STDDEV_POP)
  • STANDARD DEVIATION OF A SAMPLE (STDDEV_SAMP)
  • SUM
  • VARIANCE OF A POPULATION (VAR_POP)
  • VARIANCE OF A SAMPLE (VAR_SAMP)