大家在應(yīng)用DB2的時(shí)候可能會(huì)遇到一些看似簡(jiǎn)單的問題,特別對(duì)新手來(lái)說(shuō),我在此簡(jiǎn)單的總結(jié)一下,發(fā)布給大家,希望對(duì)大家能有所幫助,同時(shí)也歡迎大家一起探討,共同發(fā)展,共同進(jìn)步!
以下主要以DB27.X為基礎(chǔ)的.以下的字符為小寫.
本文對(duì)DB2高手來(lái)說(shuō)是不用看的.
DB2函數(shù)
135.AVG()
返回一組數(shù)值的平均值.
SELECTAVG(SALARY)FROMBSEMPMS;
136.CORR(),CORRELATION()
返回一對(duì)數(shù)值的關(guān)系系數(shù).
SELECTCORRELATION(SALARY,BONUS)FROMBSEMPMS;
137.COUNT()
返回一組行或值的個(gè)數(shù).
SELECTCOUNT(*)FROMBSEMPMS;
138.COVAR(),COVARIANCE()
返回一對(duì)數(shù)值的協(xié)方差.
SELECTCOVAR(SALARY,BONUS)FROMBSEMPMS;
139.MAX()
返回一組數(shù)值中的最大值.
SELECTMAX(SALARY)FROMBSEMPMS;
140.MIN()
返回一組數(shù)值中的最小值.
SELECTMIN(SALARY)FROMBSEMPMS;
141.STDDEV()
返回一組數(shù)值的標(biāo)準(zhǔn)偏差.
SELECTSTDDEV(SALARY)FROMBSEMPMS;
142.SUM()
返回一組數(shù)據(jù)的和.
SELECTSUM(SALARY)FROMBSEMPMS;
143.VAR(),VARIANCE()
返回一組數(shù)值的方差.
SELECTVARIANCE(SALARY)FROMBSEMPMS;
144.ABS(),ABSVAL()
返回參數(shù)的絕對(duì)值.
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;
