使用oracle来计算方差及标准差

最新推荐文章于 2024-07-21 14:50:22 发布

tswisdom

最新推荐文章于 2024-07-21 14:50:22 发布

阅读量8.6k

点赞数

分类专栏： Oracle Database 文章标签： oracle

本文链接：https://blog.csdn.net/tswisdom/article/details/7598928

版权

Oracle Database 专栏收录该内容

82 篇文章 0 订阅

订阅专栏

/* 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