IBM DB2 日常維護匯總（七）
2019-09-08 23:34:35
供稿：網(wǎng)友
DB2函數(shù)
135.AVG()
返回一組數(shù)值的平均值.
SELECTAVG(SALARY)FROMBSEMPMS;
136.CORR(),CORRELATION()
返回一對數(shù)值的關系系數(shù).
SELECTCORRELATION(SALARY,BONUS)FROMBSEMPMS;
137.COUNT()
返回一組行或值的個數(shù).
SELECTCOUNT(*)FROMBSEMPMS;
138.COVAR(),COVARIANCE()
返回一對數(shù)值的協(xié)方差.
SELECTCOVAR(SALARY,BONUS)FROMBSEMPMS;
139.MAX()
返回一組數(shù)值中的最大值.
SELECTMAX(SALARY)FROMBSEMPMS;
140.MIN()
返回一組數(shù)值中的最小值.
SELECTMIN(SALARY)FROMBSEMPMS;
141.STDDEV()
返回一組數(shù)值的標準偏差.
SELECTSTDDEV(SALARY)FROMBSEMPMS;
142.SUM()
返回一組數(shù)據(jù)的和.
SELECTSUM(SALARY)FROMBSEMPMS;
143.VAR(),VARIANCE()
返回一組數(shù)值的方差.
SELECTVARIANCE(SALARY)FROMBSEMPMS;
144.ABS(),ABSVAL()
返回參數(shù)的絕對值.
SELECTABS(-3.4)FROMBSEMPMS;
145.ACOS()
返回參數(shù)的反余弦值.
SELECTACOS(0.9)FROMBSEMPMS;
146.ASCII()
返回整數(shù)參數(shù)最左邊的字符的ASCII碼.
SELECTASCII('R')FROMBSEMPMS;
147.ASIN()
返回用弧度表示的角度的參數(shù)的反正弦函數(shù).
SELECTASIN(0.9)FROMBSEMPMS;
148.ATAN()
返回參數(shù)的反正切值,該參數(shù)用弧度表示的角度的參數(shù).
SELECTATAN(0.9)FROMBSEMPMS;
149.ATAN2()
返回用弧度表示的角度的X和Y坐標的反正切值.
SELECTATAN2(0.5,0.9)FROMBSEMPMS;
150.BIGINT()
返回整型常量中的數(shù)字或字符串的64位整數(shù)表示.
SELECTBIGINT(EMP_NO)FROMBSEMPMS;
151.CEILING()ORCEIL()
返回比參數(shù)大或等于參數(shù)的最小的整數(shù)值.
SELECTCEILING(3.56)FROMBSEMPMS;
SELECTCEIL(4.67)FROMBSEMPMS;
152.CHAR()
返回日期時間型,字符串,整數(shù),十進制或雙精度浮點數(shù)的字符串表示.
SELECTCHAR(SALARY,',')FROMBSEMPMS;
153.CHR()
返回具有由參數(shù)指定的ASCII碼的字符.
SELECTCHAR(167)FROMBSEMPMS;
