NORMALIZE Clause Syntax | SQL SELECT Statements | Teradata Vantage - 17.05 - NORMALIZE Clause Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
NORMALIZE [ ON { MEETS [ OR OVERLAPS ] | OVERLAPS [ OR MEETS ] } ]

Syntax Elements

NORMALIZE
The result of the select is normalized on the first period column in the select list. Period values that meet or overlap are coalesced, that is, combined to form a period that encompasses the individual period values.
Any period columns that are specified after the first period column are treated as regular column values. Normalize is the last operation performed on the result of a SELECT statement. You can use a SELECT statement with the normalize clause on a normalized or non-normalized table.
A SELECT statement cannot normalize a derived period column.
ON MEETS OR OVERLAPS
Period values that meet or overlap are to be coalesced, that is, combined to form a period that encompasses the individual period values.
ON OVERLAPS
Period values that overlap are to be coalesced, that is, combined to form a period that encompasses the individual period values.
ON OVERLAPS OR MEETS
Period values that overlap or meet are to be coalesced, that is, combined to form a period that encompasses the individual period values.