Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MYSQL > Numerical functions > Flashcards

Numerical functions Flashcards

1
Q

ABS

A

Returns the absolute value of a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ACOS

A

Returns the arc cosine of a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ASIN

A

Returns the arc sine of a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

ATAN

A

Returns the arc tangent of one or two numbers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ATAN2

A

Returns the arc tangent of two numbers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

AVG

A

Returns the average value of an expression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

CEIL

A

Returns the smallest integer value that is >= to a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

CEILING

A

Returns the smallest integer value that is >= to a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

COS

A

Returns the cosine of a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

COT

A

Returns the cotangent of a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

COUNT

A

Returns the number of records returned by a select query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

DEGREES

A

Converts a value in radians to degrees

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

DIV

A

Used for integer division

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

EXP

A

Returns e raised to the power of a specified number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

FLOOR

A

Returns the largest integer value that is <= to a number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

GREATEST

A

Returns the greatest value of the list of arguments

17
Q

LEAST

A

Returns the smallest value of the list of arguments

18
Q

LN

A

Returns the natural logarithm of a number

19
Q

LOG

A

Returns the natural logarithm of a number, or the logarithm of a number to a specified base

20
Q

LOG10

A

Returns the natural logarithm of a number to base 10

21
Q

LOG2

A

Returns the natural logarithm of a number to base 2

22
Q

MAX

A

Returns the maximum value in a set of values

23
Q

MIN

A

Returns the minimum value in a set of values

24
Q

MOD

A

Returns the remainder of a number divided by another number

25
Q

PI

A

Returns the value of PI

26
Q

POW

A

Returns the value of a number raised to the power of another number

27
Q

POWER

A

Returns the value of a number raised to the power of another number

28
Q

RADIANS

A

Converts a degree value into radians

29
Q

RAND

A

Returns a random number

30
Q

ROUND

A

Rounds a number to a specified number of decimal places

31
Q

SIGN

A

Returns the sign of a number

32
Q

SQRT

A

Returns the square root of a number

33
Q

SUM

A

Calculates the sum of a set of values

34
Q

TAN

A

Returns the tangent of a number

35
Q

TRUNCATE

A

Truncates a number to the specified number of decimal places

MYSQL (19 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions