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.
- 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.
ANSI Compliance
NORMALIZE is a Teradata extension to the ANSI SQL:2011 SQL standard.