oracle 计算标准差函数,Oracle数据库之使用oracle来计算方差及标准差

本文主要向大家介绍了Oracle数据库之使用oracle来计算方差及标准差，通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。

/* 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)    说明：VAR_POP 为函数， sal为要求的数据列，  以‘deptno’为分组的根据，即满足这个条件下才进行方差的操作，最后根据‘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有所帮助，更多内容请关注职坐标数据库Oracle数据库频道！