GROUP BY TIME Clause | Teradata Vantage - 17.10 - GROUP BY TIME Clause - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1208-171K
Language
English (United States)

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.