中位数查询方法:
方法1:
set @rowindex=0;
select avg(num) from (select @rowindex:= @rowindex+1 as rowindex,num from middle order by num) g where g.rowindex in (floor(@rowindex/2),ceiling(@rowindex/2));
方法2:
SELECT (SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(num ORDER BY num ),',',floor((1+Count(1))/2)),',',-1)+SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(num ORDER BY num ),',',ceiling((1+Count(1))/2)),',',-1))/2 FROM `middle `