Hello all,
How can I calculate the mean/median/mode from a set of data using SQL?
Mean seems to exist as the average (avg): select name, avg(value) from table group by name
Is there a way to calculate median and mode with a group by clause?
Median: the value at which 50% of the samples are above and below that value.
Mode: the most common value
Regards, - Robert
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
