mysql求一列的中位数

程序猿小柒

已于 2024-09-13 14:16:58 修改

阅读量285

点赞数

分类专栏：大数据文章标签： mysql sql 数据库

于 2021-10-12 15:09:42 首次发布

本文链接：https://blog.csdn.net/qq_14815605/article/details/120723998

版权

大数据专栏收录该内容

18 篇文章 0 订阅

订阅专栏

mysql如何求一列的中位数

select 
	avg(ttt.show_raw)
from 
 (select 
 	t.show_raw,
 	@row_number:=@row_number+1 as rank from 
 (select 
 		show_raw 
 from test.show_table where date='2021-09-17' order by show_raw asc)t ,(select @row_number:=0)tt)ttt
 where  ttt.rank between (select count(*)  from test.show_table where date='2021-09-17' )/2.0 and (select count(*)  from test.show_table where date='2021-09-17' )/2.0+1