sql numeric functions

1ABS Returns the absolute value of the given number.
2ACOS Returns the arc cosine of the given number.
3ASIN Returns the arc sine of the given number.
4ATAN Returns the arc tangent of one or 2 given numbers.
5ATAN2 Return the arc tangent of 2 given numbers.
6AVG Returns the average value of the given expression.
7CEIL Returns the closest whole number (integer) upwards from a given
8decimal point number.
9CEILING Same as CEIL.
10COS Returns the cosine of a given number.
11COT Returns the cotangent of a given number.
12COUNT Returns the amount of records that are returned by a SELECT query.
13DEGREES Converts a radians value to degrees.
14DIV Allows you to divide integers.
15EXP Returns e to the power of the given number.
16FLOOR Returns the closest whole number (integer) downwards from a given
17decimal point number.
18GREATEST Returns the highest value in a list of arguments.
19LEAST Returns the smallest value in a list of arguments.
20LN Returns the natural logarithm of the given number
21LOG Returns the natural logarithm of the given number, or the logarithm of
22the given number to the given base
23LOG10 Does the same as LOG, but to base 10.
24LOG2 Does the same as LOG, but to base 2.
25MAX Returns the highest value from a set of values.
26MIN Returns the lowest value from a set of values.
27MOD Returns the remainder of the given number divided by the other given
28number.
29PI Returns PI.
30POW Returns the value of the given number raised to the power of the other
31given number.
32POWER Same as POW.
33RADIANS Converts a degrees value to radians.
34RAND Returns a random number.
35ROUND Round the given number to the given amount of decimal places.
36SIGN Returns the sign of the given number.
37SIN Returns the sine of the given number.
38SQRT Returns the square root of the given number.
39SUM Returns the value of the given set of values combined.
40TAN Returns the tangent of the given number.
41TRUNCATE Returns a number truncated to the given number of decimal places.