17.10 - Traditional Aggregate Functions that Support Time Series - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)
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)