This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

MEDIAN

Calculates an approximate median for a given column.

Syntax

MEDIAN(<col>)

Example

For this example, we’ll create a new table num_test as shown below:

CREATE DIMENSION TABLE IF NOT EXISTS num_test
	(
		num INT
	);

INSERT INTO
	num_test
VALUES
	(1),
	(7),
	(12),
	(30),
	(59),
	(76),
	(100);

MEDIAN returns the approximate middle value between the lower and higher halves of the values.

SELECT
	MEDIAN(num)
FROM
	number_test

Returns: 30