ABS | Computes the absolute value of a numeric expression. |
ACOS | Computes the arccosine (inverse cosine) of a value in radians. |
ASIN | Computes the arcsine (inverse sine) of a value in radians. |
ATAN | Computes the Arctangent (inverse Tangent) of a value. |
ATAN2 | Computes the Arctangent (inverse Tangent) of the ratio of its two arguments. |
BROUND | Returns the rounded result of the numeric expression using HALF_EVEN rounding mode. |
CBRT | Computes the cube root of a numeric expression. |
CEILING | Returns the nearest equal or larger value of the input expression. Can also be called using CEIL(). |
COS | Computes the cosine of a value in radians. |
COSH | Computes the hyperbolic cosine of a value in radians. |
COT | Computes the cotangent of a value in radians. |
DEGREES | Converts radians to degrees. |
E | Returns Euler's number, a constant approximately equal to 2.718281828459045. |
EXP | Calculates Euler's number, e, raised to the power of the specified value. |
FACTORIAL | Computes the factorial of the numeric expression. The input expression must be an integer from 0 to 20 . |
FLOOR | Returns the value from the specifed expression rounded to the nearest equal or smaller integer. |
LN | Returns the natural logarithm of of the numeric expression. |
LOG | Returns the logarithm of the numeric input expression. If no base is specified, the natural log (ln) will be calculated. |
LOG10 | Returns the log base 10 of the numeric input expression. |
MOD | Returns the remainder of the input expression divided by the second input expression. |
PI | Returns the value of pi, which is approximately 3.14592654. |
PMOD | Returns the positive remainder after dividend / divisor. Returns an error if the divisor is 0. |
POW, POWER | Returns the result of raising the input value to the specified power. |
RADIANS | Convert a value in degrees to radians. |
RANDOM | Each call returns a random generated number between 0 and 1 for each row. |
ROUND | Returns the rounded value for the inputted value. If no scale is specified, the closest whole number is returned. |
SIGN | Returns the sign of the input expression. |
SIN | Computes the sine of a value. |
SINH | Computes the hyperbolic sine of the input expression. |
SQRT | Returns the square root of the non-negative numeric expression. |
STDDEV | Returns the standard deviation of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL. |
STDDEV_POP | Returns the population standard deviation (square root of variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL. |
STDDEV_SAMP | Returns the sample standard deviation (square root of sample variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL. |
TAN | Computes the tangent of a value in radians. |
TANH | Computes the hyperbolic tangent of the input expression. |
TRUNCATE | Rounds the input expression down the nearest of equal integer depending on the specified number of places before or after the decimal point. |