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 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.
- 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
- That the results are to be ordered in ascending sort order.
- If the sort field is a character string, the system orders it in ascending order according to the definition of the collation sequence for the current session.
- The default order is ASC.
- DESC
- That the results are to be ordered in descending sort order.
- If the sort field is a character string, the system orders it in descending order according to the definition of the collation sequence for the current session.