mysql中位数

SELECT AVG(your_column) AS median
FROM (
    SELECT your_column
    FROM your_table
    ORDER BY your_column
    LIMIT 2 - (SELECT COUNT(*) FROM your_table) % 2    -- 奇数行数取1，偶数行数取2
    OFFSET (SELECT (COUNT(*) - 1) / 2 FROM your_table) -- 偏移量
) AS x;

CREATE TEMPORARY TABLE temp_sorted AS (
    SELECT your_column
    FROM your_table
    ORDER BY your_column
);

SELECT AVG(your_column) AS median
FROM (
    SELECT your_column
    FROM temp_sorted
    LIMIT 2 - (SELECT COUNT(*) FROM temp_sorted) % 2
    OFFSET (SELECT (COUNT(*) - 1) / 2 FROM temp_sorted)
) AS x;