MEDIAN ( [ DISTINCT | ALL ] 'value_expression' )
- All non-null value_expressions, including duplicates.
- Excludes duplicates specified by 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.