时间: 2021-08-13 作者:daque
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; 149.atan2() 归来用弧度表白的观点的x和y坐目标归正切值. selectatan2(0.5,0.9)frombsempms; 150.bigint() 归来整型恒量中的数字或字符串的64位平头表白. selectbigint(emp_no)frombsempms; 151.ceiling()orceil() 归来比参数大或即是参数的最小的平头值. selectceiling(3.56)frombsempms; selectceil(4.67)frombsempms; 152.char() 归来日子功夫型,字符串,平头,十进制或双精度浮点数的字符串表白. selectchar(salary,',')frombsempms; 153.chr() 归来具备由参数指定的ascii码的字符. selectchar(167)frombsempms;