MAVG ( value_expression, width, sort_spec [,...] )
Syntax Elements
- value_expression
- 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 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.
- For example, MAVG(Sale, 6, Region ASC, Store DESC), where Sale is the value_expression, 6 is the width, and Region ASC, Store DESC is the sort_expression list.
- The expression cannot contain any ordered analytical or aggregate functions.
- ASC
- Results are to be ordered in ascending sort order.
- If the sort field is a character string, the system orders the field in ascending order according to the definition of the collation sequence for the current session.
- The default order is ASC.
- DESC
- Results are to be ordered in descending sort order.
- If the sort field is a character string, the system orders the field in descending order according to the definition of the collation sequence for the current session.