# Teradata window aggregate functions

Window aggregate function is an aggregate function on which a window specification is applied.

Window aggregate functions in Teradata can be used to generate reports showing sub-count, sub-total, final count , final total, moving sum, cumulative sum, moving average and moving difference.

Teradata window aggregate functions are used to perform OLAP analysis data operations and data mining in a data mart or a data warehouse.

Window functions in Teradata may be performed on tables, views and INSERT or SELECT statements and are recognized by the **OVER()** clause.

Examples of ANSI-compliant window aggregate functions in Teradata:

Teradata non-Ansi extensions to window aggregate functions:

__Note that the output from WITH and WITH...BY is non-relational!__