Answers for "how to get the median in mysql"

median mysql

SELECT x.val from data x, data y
GROUP BY x.val
HAVING SUM(SIGN(1-SIGN(y.val-x.val))) = (COUNT(*)+1)/2

Posted by: Guest on November-22-2020

Code answers related to "how to get the median in mysql"