Math/Numeric Functions Flashcards
1
Q
ABS
A
returns the absolute value of a number
2
Q
ACOS
A
returns the arc cosine of a number
3
Q
ASIN
A
returns the arc sine of a number
4
Q
ATAN
A
return the arc tangent of a number
5
Q
ATN2
A
returns the arc tangent of two numbers
6
Q
AVG
A
returns the average value of an expression
7
Q
CEILING
A
returns the smallest integer value that is >= a number
8
Q
COUNT
A
returns the number of records returned by a select query
9
Q
COS
A
returns the cosine of a number
10
Q
COT
A
returns the cotangent of a number
11
Q
DEGREES
A
converts a value in radians to degrees
12
Q
EXP
A
returns e raised to the power of a specified number
13
Q
FLOOR
A
returns the largest integer value that is <= to a number
14
Q
LOG
A
returns the natural logarithm of a number, or the logarithm of a number to a specified base
15
Q
LOG10
A
returns the natural logarithm of a number to base 10
