MovingAverage Output - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™

Output Table Schema

Column Data Type Description
partition_column Same as in input table Column by which input data is partitioned.
order_column Same as in input table Column by which input table is ordered.
target_column Same as in input table Column copied from input table.
target_column_typemavg DOUBLE PRECISION Moving average of target_column values when row was added to data set, where type is value of MAvgType syntax element.