| 函數 | 說明 | 示例 |
|---|
AVG(expr) | 平均值 | SELECT AVG(SALARY) FROM BSEMPMS |
CORR/CORRELATION(expr1, expr2) | 相關係數 | SELECT CORRELATION(SALARY, BONUS) FROM BSEMPMS |
COUNT(*) / COUNT(expr) | 行數/非空值個數 | SELECT COUNT(*) FROM BSEMPMS |
COVAR/COVARIANCE(expr1, expr2) | 協方差 | SELECT COVAR(SALARY, BONUS) FROM BSEMPMS |
MAX(expr) | 最大值 | SELECT MAX(SALARY) FROM BSEMPMS |
MIN(expr) | 最小值 | SELECT MIN(SALARY) FROM BSEMPMS |
STDDEV(expr) | 標準差 | SELECT STDDEV(SALARY) FROM BSEMPMS |
SUM(expr) | 求和 | SELECT SUM(SALARY) FROM BSEMPMS |
VAR/VARIANCE(expr) | 方差 | SELECT VARIANCE(SALARY) FROM BSEMPMS |
