mysql的一些查询技巧

中位数查询方法：

方法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 `