Summary of routine maintenance of IBM DB2 (7)

The db2 tutorial is: Daily maintenance Summary of IBM DB2 (7 ). DB2 Functions
135. AVG ()
Returns the average value of a set of values.
SELECTAVG (SALARY) FROMBSEMPMS;
　　
136. CORR (), CORRELATION ()
Returns the relational coefficient of a number.
SELECTCORRELATION (SALARY, BONUS) FROMBSEMPMS;
　　
137. COUNT ()
Returns the number of rows or values.
SELECTCOUNT (*) FROMBSEMPMS;
　　
138. COVAR (), COVARIANCE ()
Returns the covariance of a value.
SELECTCOVAR (SALARY, BONUS) FROMBSEMPMS;
　　
139. MAX ()
Returns the maximum value of a group of values.
SELECTMAX (SALARY) FROMBSEMPMS;

140. MIN ()
Returns the minimum value 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 the sum.
SELECTSUM (SALARY) FROMBSEMPMS;
　　
143. VAR (), VARIANCE ()
Returns the variance of a set of values.
SELECTVARIANCE (SALARY) FROMBSEMPMS;
　　
144. ABS (), ABSVAL ()
Returns the absolute value of a parameter.
SELECTABS (-3.4) FROMBSEMPMS;
　　
145. ACOS ()
Returns the arc cosine of a 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 arcsin function of the Angle Parameter in radians.
SELECTASIN (0.9) FROMBSEMPMS;
　　
148. ATAN ()
Returns the arc tangent of a parameter, which is an Angle Parameter in radians.
SELECTATAN (0.9) FROMBSEMPMS;
　　
149. ATAN2 ()
Returns the arc tangent of the angle X and Y coordinates in radians.
SELECTATAN2 (0.5, 0.9) FROMBSEMPMS;
　　
150. BIGINT ()
Returns the 64-bit integer representation of a number or string in an integer constant.
SELECTBIGINT (EMP_NO) FROMBSEMPMS;
　　
151. CEILING () ORCEIL ()
Returns the smallest integer value greater than or equal to the parameter.
SELECTCEILING (3.56) FROMBSEMPMS;
SELECTCEIL (4.67) FROMBSEMPMS;
　　
152. CHAR ()
Returns the string representation of the datetime type, String, integer, decimal or double-precision floating point number.
SELECTCHAR (SALARY, ',') FROMBSEMPMS;
　　
153. CHR ()
Returns the characters with the specified ASCII code.
SELECTCHAR (167) FROMBSEMPMS;

　　
<