16.20 - NORMALIZE - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Manipulation Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1146-162K

Period values in the first period column that meet or overlap are combined to form a period that encompasses the individual period values.

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.
table_name
Name of a table for which all the attributes of all its structured UDT columns are to be returned.
column_name
Name of a column in the named query definition.
You can specify a row-level table constraint column in the select list of a SELECT statement, as long as it is not part of an arithmetic expression. The value returned for the column is the coded value for the row-level security constraint from the row.
Columns with a UDT type are valid with some exceptions. See Specifying UDTs in an SQL Request.
You cannot specify LOB columns with NORMALIZE.

ANSI Compliance

NORMALIZE is a Teradata extension to the ANSI SQL:2011 SQL standard.