GROUP BY TIME Clause | Teradata Vantage - 17.00 - GROUP BY TIME Clause - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1208-170K

The GROUP BY TIME clause is an enhancement to the SELECT statement that allows a set of aggregate functions to be computed on data grouped in terms of time. Although the grouping is optimized for PTI tables, it is also supported on non-PTI tables because a timecode column is explicitly specified in the USING TIMECODE clause.

The syntax diagram and descriptions discuss only the portions of the SELECT syntax that are specific to the GROUP BY TIME clause. For information about the other syntax that you can use with SELECT, see Teradata Vantageā„¢ - SQL Data Manipulation Language, B035-1146.