NORMALIZE Clause Syntax | SQL SELECT Statements | Teradata Vantage - NORMALIZE Clause Syntax - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
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.