Skip to content

Latest commit

 

History

History
3 lines (2 loc) · 3.94 KB

File metadata and controls

3 lines (2 loc) · 3.94 KB

Math

Function NameDescription
ABSComputes the absolute value of a numeric expression.
ACOSComputes the arccosine (inverse cosine) of a value in radians.
ASINComputes the arcsine (inverse sine) of a value in radians.
ATANComputes the Arctangent (inverse tangent) of a value.
CBRTComputes the cube root of a numeric expression.
CEILINGReturns the nearest equal or larger value of the input expression. Can also be called using CEIL().
COSComputes the cosine of a value in radians.
COSHComputes the hyperbolic cosine of a value in radians.
COTComputes the cotangent of a value in radians.
DEGREESConverts radians to degrees.
EReturns Euler’s number, a constant approximately equal to 2.718281828459045.
EXPCalculates Euler’s number, e, raised to the power of the specified value.
FLOORReturns the value from the specified expression rounded to the nearest equal or smaller integer.
LOGReturns the logarithm of the numeric input expression. If no base is specified, the natural log (ln) will be calculated.
LOG10Returns the log base 10 of the numeric input expression.
MODReturns the remainder of the input expression divided by the second input expression.
PIReturns the value of pi, which is approximately 3.14592654.
POWERReturns the result of raising the input value to the specified power.
RADIANSConvert a value in degrees to radians.
ROUNDReturns the rounded value for the inputted value. If no scale is specified, the closest whole number is returned.
SIGNReturns the sign of the input expression.
SINComputes the sine of a value.
SINHComputes the hyperbolic sine of the input expression.
SQRTReturns the square root of the non-negative numeric expression.
STDDEVReturns 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_POPReturns 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_SAMPReturns 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.
TANComputes the tangent of a value in radians.
TANHComputes the hyperbolic tangent of the input expression.
TRUNCATERounds the input expression down the nearest of equal integer depending on the specified number of places before or after the decimal point.