mysql求中位数
2024-09-01 05:09:01
实例1:
SET @ID = 0;
SELECT
AVG(loan_amount)
from
(
SELECT @ID:=@ID+1 as ID, loan_amount
FROM table_xxx ORDER BY loan_amount
) a where IF( ROUND(@ID/2,0)%2=0,ID in (ROUND(@ID/2,0),ROUND(@ID/2,0)/2 + 1), ID=ROUND(@ID/2,0) )
实例2:
SET @ID = 0;
SELECT
AVG(totallimit)
from
(
SELECT @ID:=@ID+1 as ID,t.*
FROM
(
SELECT pp.capitalid, pp.totallimit
FROM table1 pp
INNER JOIN table2 ppc ON pp.capitalid = ppc.capitalid
WHERE
pp.isduifu = 0
and pp.inserttimestamp <='2019-05-31 23:59:59'
and ppc.faxingjigou like '%R360%'
ORDER BY pp.totallimit
) t
) a where IF( ROUND(@ID/2,0)%2=0,ID in (ROUND(@ID/2,0),ROUND(@ID/2,0) + 1), ID=ROUND(@ID/2,0) );
最新文章
- AMD and CMD are dead之KMDjs内核之分号
- android之fragment
- Linux学习笔记19-ssh远程管理
- 三、jQuery--jQuery基础--jQuery基础课程--第4章 jQuery表单选择器
- WPF标注装饰器
- web服务器安装配置
- Android控件之CheckBox(复选框控件)
- 用fscanf()从文件取数据时,如何判断文件结束
- CMDB反思2
- Oracle SQL的硬解析、软解析、软软解析
- WHY IE AGAIN? - string.charAt(x) or string[x]?
- keepalived vip漂移基本原理及选举算法
- hdu 1028 母函数 一个数有几种相加方式
- sqlserver查询所有表的行数的sql语句
- Openlayers 3 图层探查功能
- 滚动视图(ScrollView)的功能与用法
- ------ 解析因内核栈溢出导致的 “double fault” 蓝屏 ------
- 比较工具diif-vimdiff-windows比较工具详解
- How to Simulate the Price Order or Price Line Function using API QP_PREQ_PUB.PRICE_REQUEST Includes
- linux服务基础(一)之CentOS6编译安装httpd2.4
热门文章
- MongoDB 查看当前配置
- UFUN函数 UF_CSYS UF_MODL UF_OBJ函数(建模注意坐标系);
- firewall-cmd命令的富语言(richlanguage)示例
- JS的ES5的扩展内容
- flag&;to do list&;note
- node解析修改ngix配置文件
- mysql(一)工作原理 &; 数据库引擎
- [Gamma]Scrum Meeting#4
- NOTIC: [8] Trying to get property of non-object
- cesium地形瓦片(Quantized-mesh)格式