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.