median¶
This function is used to calculate the median of input parameters.
Syntax¶
median(colname)
Parameters¶
Parameter | Mandatory | Type | Description |
|---|---|---|---|
colname | Yes | DOUBLE, DECIMAL, STRING, or BIGINT | Name of the column to be sorted The elements in a column are of the DOUBLE type. If an element in a column is not of the DOUBLE type, the system will implicitly convert it to the DOUBLE type for calculation. |
Return Values¶
The return value is of the DOUBLE or DECIMAL type.
Note
If the column name does not exist, an error is reported.
Example Code¶
Assume that the elements in the int_test column are 1, 2, 3, and 4 and they are of the INT type.
The value 2.5 is returned.
select median(int_test) FROM int_test;