Re: How do I get the median instead of average?

[Rick James]

Something like this will get you the median value:

CREATE TEMPORARY TABLE t (
    seq INT UNSIGNED AUTO_INCREMENT,
    PRIMARY KEY (seq)
)
    SELECT val
        FROM your_table
        ORDER BY val;
SELECT @half := FLOOR(COUNT(*)/2)
    FROM t;
SELECT @median := val
    FROM t
    WHERE seq = @half;