db2函数大全（DB2 function Daquan）.doc

db2函数大全（DB2 function Daquan） Examples of function name function interpretation functions AVG () returns the average value of a set of values. SELECTAVG (SALARY) FROMBSEMPMS; CORR (), CORRELATION () returns the relational coefficient of a pair of values. SELECTCORRELATION (SALARY, BONUS) FROMBSEMPMS; COUNT () returns the number of rows or values. SELECTCOUNT (*) FROMBSEMPMS; COVAR (), COVARIANCE () returns the covariance of a pair of values. SELECTCOVAR (SALARY, BONUS) FROMBSEMPMS; MAX () returns the maximum value in a set of values. SELECTMAX (SALARY) FROMBSEMPMS; MIN () returns the minimum value in a set of values. SELECTMIN (SALARY) FROMBSEMPMS; STDDEV () returns the standard deviation of a set of values. SELECTSTDDEV (SALARY) FROMBSEMPMS; SUM () returns the sum of a set of data. SELECTSUM (SALARY) FROMBSEMPMS; VAR (), VARIANCE () returns the variance of a set of values. SELECTVARIANCE (SALARY) FROMBSEMPMS; ABS (), ABSVAL () returns the absolute value of the parameter. SELECTABS (-3.4) FROMBSEMPMS; ACOS () returns the inverse cosine value of the parameter. SELECTACOS (0.9) FROMBSEMPMS; ASCII () returns the ASCII code of the leftmost character of the integer argument. SELECTASCII (R) FROMBSEMPMS; ASIN () returns the inverse sine function of the angle represented by radians. SELECTASIN (0.9) FROMBSEMPMS; ATAN () returns the tangent value of the parameter, the argument in radians of the parameter. SELECTATAN (0.9) FROMBSEMPMS; ATAN2 () returns the tangent value of the X and Y coordinates of the angle represented by radians. SELECTATAN2 (0.5,0.9) FROMBSEMPMS; BIGINT () returns the 64 bit integer representation of the number in the integer constant or the string. SELECTBIGINT (EMP_NO) FROMBSEMPMS; CEILING () OR, CEIL () returns the smallest integer value greater than or equal to the parameter. SELECTCEILING (3.56) FROMBSEMPMS; SELECTCEIL (4.67) FROMBSEMPMS; CHAR () returns the string representation of the date, time, string, integer, decimal, or double precision floati