提供標準 SQL 語法與範例，便於開發與維護人員快速查閱驗證。
| 函數 | 說明 | 範例 |
|---|---|---|
| AVG() | 平均值 | SELECT AVG(SALARY) FROM BSEMPMS |
| CORR() / CORRELATION() | 相關係數 | SELECT CORRELATION(SALARY, BONUS) FROM BSEMPMS |
| COUNT() | 計數 | SELECT COUNT(*) FROM BSEMPMS |
| COVAR() / COVARIANCE() | 協方差 | SELECT COVAR(SALARY, BONUS) FROM BSEMPMS |
| MAX() | 最大值 | SELECT MAX(SALARY) FROM BSEMPMS |
| MIN() | 最小值 | SELECT MIN(SALARY) FROM BSEMPMS |
| STDDEV() | 標準差 | SELECT STDDEV(SALARY) FROM BSEMPMS |
| SUM() | 總和 | SELECT SUM(SALARY) FROM BSEMPMS |
| VAR() / VARIANCE() | 變異數 | SELECT VARIANCE(SALARY) FROM BSEMPMS |
| 函數 | 說明 | 範例 |
|---|---|---|
| ABS() / ABSVAL() | 絕對值 | SELECT ABS(-3.4) FROM BSEMPMS |
| ACOS() | 反餘弦 | SELECT ACOS(0.9) FROM BSEMPMS |
| ASIN() | 反正弦 | SELECT ASIN(0.9) FROM BSEMPMS |
| ATAN() | 反正切 | SELECT ATAN(0.9) FROM BSEMPMS |
| ATAN2() | 座標反正切 | SELECT ATAN2(0.5, 0.9) FROM BSEMPMS |
| BIGINT() | 64 位整數 | SELECT BIGINT(EMP_NO) FROM BSEMPMS |
| CEILING() / CEIL() | 向上取整 | SELECT CEILING(3.56) FROM BSEMPMS |
| CHAR() | 數值/日期轉字串 | SELECT CHAR(SALARY, ',') FROM BSEMPMS |
| CHR() | ASCII 碼轉字元 | SELECT CHR(167) FROM BSEMPMS |
更多字串、日期、條件、型別轉換函數請參考第八、九部分及官方 SQL Reference。
