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

Teradata Vantageā„¢ - Time Series Tables and Operations

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.