TD_SUM_NORMALIZE_OVERLAP | Date/Time Functions & Expressions | Teradata Vantage - TD_SUM_NORMALIZE_OVERLAP - Advanced SQL Engine - Teradata Database

SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dzx1591742169550.ditamap
dita:ditavalPath
dzx1591742169550.ditaval
dita:id
B035-1211
lifecycle
previous
Product Category
Teradata Vantageā„¢

Finds the sum of a column for all the rows that were normalized because their Period values overlap.

Result Type

This function returns result rows with the columns specified in the RETURNS clause as follows:
  • The grouping columns specified in the input argument.
  • The Period column with normalized Period values.
  • An optional INTEGER column containing the count of the rows that were normalized because their Period values overlap.