MEDIAN ( [ DISTINCT | ALL ] 'value_expression' )
Syntax Elements
- ALL
- All non-null value_expressions, including duplicates.
- DISTINCT
- Excludes duplicates specified by value_expression.
- value_expression
- A literal or column expression for which a median is to be computed.
The value_expression cannot be a reference to a view column derived from a function, and cannot contain any ordered analytical or aggregate functions.