Everyone may encounter some seemingly simple questions when applying DB2, especially for newcomers, I have a simple summary, release it to everyone, I hope everyone can help, and also welcome everyone to discuss. Common development, common progress! The following mainly based on DB27.x. The following characters are lowercase. This article is not read for DB2 masters. DB2 functions 135.avg () returns a set of values. Selectavg Salary) fromBSempms; 136.corr (), correlation () returns a relational coefficient of a pair of values. SelectCorRelation (Salary, Bonus) fromBSempms; 137.count () Returns a number of rows or values. SelectCount (*) fromBSempms; 138.covar (), COVARIANCE () Returns a covariance of a pair of values. SELECTCOVAR (Salary, Bonus) fromBSempms; 139.max () Returns the maximum value in a set of values. Selectmax (Salary) fromBSempms; 140.min () Returns a minimum of a set of values. Selectmin (Salary) fromBSempms; 141.stddev () Returns the standard deviation of a set of values. Selectstddev (Salary) fromBSempms; 142.sum () Returns a set of data and. SelectSum (Salary) "143.VAR (), variance () returns a variance of a set of values. Selectvariance (Salary) fromBSempms; 144.abs (), absval () returns an absolute value of the parameter. Selectabs (-3.4) fromBSempms; 145.acos ) Returns the anti-cosrome value of the parameter. Selectacos (0.9) fromBSempms; 146.ascii () Returns the ASCII code of the leftmost character of the integer parameter. Selectascii ('r') fromBSempms; 147.asin () Returns the angle representation of the arc The argument of the anti-stereo function. SELECTASIN (0.9) fromBSempms; 148.atan () Returns an intermediate cut value of the parameter, this parameter The arc parameters represent the angle of the angle. Selectatan (0.9) fromBSempms;
