16.20 - MDIFF - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

prodname
Advanced SQL Engine
Teradata Database
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1145-162K

Purpose

Returns the moving difference between the specified value expression for the current row and the preceding width rows for each row in the partition.

Type

Teradata-specific function.

Syntax