Finds the count of a column for all adjacent periods in normalized rows whose Period values either meet or overlap.
Syntax
[TD_SYSFNLIB.] TD_SEQUENCED_COUNT ( grouping_column_list, numeric_column, period_column )
- grouping_column_list
- One or more grouping columns, not including the Period column. You must specify the input as a dynamic UDT.
- period_column
-
An expression that results in a DATE, TIMESTAMP, or TIMESTAMP WITH TIME ZONE value.
- TD_SYSFNLIB.
- Name of the database where the function is located.