Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

4.3 KiB

Raw Permalink Blame History

median

This function is used to calculate the median of input parameters.

Syntax

median(colname)

Parameters

**Table 1** Parameter
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.

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;

Parent topic: Mathematical Functions

4.3 KiB Raw Permalink Blame History