Numerical functions Flashcards
ABS
Returns the absolute value of a number
ACOS
Returns the arc cosine of a number
ASIN
Returns the arc sine of a number
ATAN
Returns the arc tangent of one or two numbers
ATAN2
Returns the arc tangent of two numbers
AVG
Returns the average value of an expression
CEIL
Returns the smallest integer value that is >= to a number
CEILING
Returns the smallest integer value that is >= to a number
COS
Returns the cosine of a number
COT
Returns the cotangent of a number
COUNT
Returns the number of records returned by a select query
DEGREES
Converts a value in radians to degrees
DIV
Used for integer division
EXP
Returns e raised to the power of a specified number
FLOOR
Returns the largest integer value that is <= to a number