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

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qtb1554762060450.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™
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.