时间: 2021-08-13 作者:daque
大师在运用db2的功夫大概会遇到少许看似大略的题目,更加对生人来说,我在此大略的归纳一下,颁布给大师,蓄意对大师能有所扶助,同声也欢送大师一道商量,共通兴盛,共通超过!以次重要以db27.x为普通的.以次的字符为小写. 正文对db2能手来说是不必看的. db2因变量 135.avg() 归来一组数值的平衡值. selectavg(salary)frombsempms; 136.corr(),correlation() 归来一对数值的联系系数. selectcorrelation(salary,bonus)frombsempms; 137.count() 归来一组行或值的个数. selectcount(*)frombsempms; 138.covar(),covariance() 归来一对数值的协方差. selectcovar(salary,bonus)frombsempms; 139.max() 归来一组数值中的最大值. selectmax(salary)frombsempms; 140.min() 归来一组数值中的最小值. selectmin(salary)frombsempms; 141.stddev() 归来一组数值的规范缺点. selectstddev(salary)frombsempms; 142.sum() 归来一组数据的和. selectsum(salary)frombsempms; 143.var(),variance() 归来一组数值的方差. selectvariance(salary)frombsempms; 144.abs(),absval() 归来参数的一致值. selectabs(-3.4)frombsempms; 145.acos() 归来参数的反余弦值. selectacos(0.9)frombsempms; 146.ascii() 归来平头参数最左边的字符的ascii码. selectascii('r')frombsempms; 147.asin() 归来用弧度表白的观点的参数的归正弦因变量. selectasin(0.9)frombsempms; 148.atan() 归来参数的归正切值,该参数用弧度表白的观点的参数. selectatan(0.9)frombsempms;