MDIFF ( value_expression, width, sort_spec [,...] )
Syntax Elements
-
value_expression
- A numeric column or literal expression for which a moving difference is to be computed.
- The expression cannot contain any ordered analytical or aggregate functions.
-
width
- The number of previous rows to be used in the computation.
- The value is always a positive integer literal.
- The maximum is 4096.
-
sort_spec
-
sort_expression [ ASC | DESC ]
-
sort_expression
- A literal or column expression or comma-separated list of literal or column expressions to be used to sort the values.
- ASC
- Ascending sort order.
- DESC
- Descending sort order.