MDIFF Function | VantageCloud Lake - MDIFF - Teradata VantageCloud Lake

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

• MDIFF Function Syntax
• MDIFF Result Type and Attributes
• MDIFF Usage Notes
• MDIFF Function Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Type

Teradata-specific function.