使用oracle来计算方差及标准差
来源:互联网 发布:知豆电动汽车代理 编辑:程序博客网 时间:2024/04/30 08:24
/* Formatted on 5/24/2012 4:15:58 PM (QP5 v5.149.1003.31008) */
SELECT deptno,
ename, --st_name || ' ' || last_name employee_name,
hiredate,
sal,
STDDEV (sal) OVER (PARTITION BY deptno ORDER BY hiredate) AS "STDDEV", --标准差
STDDEV_SAMP (sal) OVER (PARTITION BY deptno ORDER BY hiredate)
AS "STDDEV_SAMP", --样本标准差
VAR_POP (sal) OVER (PARTITION BY deptno ORDER BY hiredate)
AS "VAR_POP", --方差
VAR_SAMP (sal) OVER (PARTITION BY deptno ORDER BY hiredate)
AS "VAR_SAMP" --样本方差
FROM scott.emp
WHERE deptno IN (20);
/* Formatted on 5/24/2012 4:15:58 PM (QP5 v5.149.1003.31008) */
SELECT deptno,
STDDEV (sal) AS "STDDEV", --标准差
STDDEV_SAMP (sal)
AS "STDDEV_SAMP", --样本标准差
VAR_POP (sal)
AS "VAR_POP", --方差
VAR_SAMP (sal)
AS "VAR_SAMP" --样本方差
FROM scott.emp
group by deptno
SELECT deptno,
ename, --st_name || ' ' || last_name employee_name,
hiredate,
sal,
STDDEV (sal) OVER (PARTITION BY deptno ORDER BY hiredate) AS "STDDEV", --标准差
STDDEV_SAMP (sal) OVER (PARTITION BY deptno ORDER BY hiredate)
AS "STDDEV_SAMP", --样本标准差
VAR_POP (sal) OVER (PARTITION BY deptno ORDER BY hiredate)
AS "VAR_POP", --方差
VAR_SAMP (sal) OVER (PARTITION BY deptno ORDER BY hiredate)
AS "VAR_SAMP" --样本方差
FROM scott.emp
WHERE deptno IN (20);
/* Formatted on 5/24/2012 4:15:58 PM (QP5 v5.149.1003.31008) */
SELECT deptno,
STDDEV (sal) AS "STDDEV", --标准差
STDDEV_SAMP (sal)
AS "STDDEV_SAMP", --样本标准差
VAR_POP (sal)
AS "VAR_POP", --方差
VAR_SAMP (sal)
AS "VAR_SAMP" --样本方差
FROM scott.emp
group by deptno
- 使用oracle来计算方差及标准差
- 使用程序计算 方差 标准差
- mahout 计算方差标准差
- hive--计算方差标准差
- matlab 计算均值,方差,标准差
- oracle 求方差和标准差
- 计算数据的平均值、方差和标准差
- 方差、标准差和协方差
- 方差、标准差和协方差
- 利用方差和标准差计算学生成绩的稳定性
- oracle数据库之统计分析(方差、标准差、协方差)
- 方差,均方差,标准差,协方差
- 浅谈均值、方差、标准差、协方差的概念及意义
- 算法--偏差,方差,标准差,协方差,相关系数及相关理解
- 方差和标准差
- 方差和标准差
- 方差和标准差
- 方差,标准差.--概率论
- wxWidgets和QT之间的选择
- ICA和RDP的区别
- poj 2312( 搜索 )
- IE6是支持!important的
- Android 之 远程图片获取和本地缓存
- 使用oracle来计算方差及标准差
- 页面提交前判断
- Web开发者应掌握的12个Firebug技巧
- CString Char *互相转化
- [黑马程序员]简单的ajax代码
- Vc++ Static 控件 显示 图片
- 校验和算法简介
- Emacs常用命令
- linux上printf出带颜色字体