WITH
T1 AS (
SELECT 1 A FROM DUAL UNION ALL
SELECT 2 A FROM DUAL UNION ALL
SELECT 3 A FROM DUAL UNION ALL
SELECT 4 A FROM DUAL UNION ALL
SELECT 5 A FROM DUAL )
SELECT
STDDEV(A) 标准偏离,
STDDEV_POP(A) 总体标准偏离,
STDDEV_SAMP(A) 累积样本标准偏离,
MEDIAN(A) 中位数 ,
VAR_POP(A) 方差 ,-- 每一个数减掉平均数后的乘方,累加,除以个数。
VAR_SAMP(A) 样本方差
FROM T1 ;
ORACLE数学统计函数
最新推荐文章于 2022-03-06 13:59:27 发布