Roger I Martin PhD writes: > Hi, > > Median as a function in sql does not exests that I know of. But if you get a > resultset ordered by the column of numbers, you can then pick the median at > the row index=n/2 where n is the total number of values in the column? > > Roger
Nope . Median depends on statistical distribution. There is one that is valid for sampling distribution, but there are still many alternatives. This is something that could be done as an UDF. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php