Looking at the DB2 tutorial is: DB2 common fool question 1000 Q (v). Everyone in the application of DB2 may encounter some seemingly simple problems, especially for beginners, I briefly summed up in this, released to everyone, hope that we can help, but also welcome everyone to explore together, common development and common progress!
The following are mainly based on db27.x. The following characters are lowercase.
This article for DB2 Master is not to see.
DB2 function
135.AVG ()
Returns the average of a set of values.
Selectavg (SALARY) Frombsempms;
136.CORR (), Correlation ()
Returns the relationship coefficient of a pair of values.
Selectcorrelation (Salary,bonus) Frombsempms;
137.COUNT ()
Returns the number of rows or values in a group.
SelectCount (*) Frombsempms;
138.COVAR (), covariance ()
Returns the 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 the smallest value in 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 and of a set of data.
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 the parameter.
Selectabs ( -3.4) Frombsempms;
145.ACOS ()
Returns the inverse cosine of a parameter.
Selectacos (0.9) Frombsempms;
146.ASCII ()
Returns the ASCII code of the leftmost character of an integer parameter.
Selectascii (' R ') Frombsempms;
147.ASIN ()
Returns the inverse chord function of the argument of the angle expressed in radians.
Selectasin (0.9) Frombsempms;
148.ATAN ()
Returns the inverse tangent of a parameter, the argument of the angle in radians.
Selectatan (0.9) Frombsempms;
<
