First page Back Continue Last page Image

Popular Number Functions

ROUND(number,length)

TRUNCATE(number,length)

CEILING(number)

FLOOR(number)

ABS(number)

SIGN(number)

SQRT(number)

POWER(number,power)

RAND([integer])

While some of these functions are designed to work with Floating point numbers (Numbers with a decimal and fractional values), they can be applied to integers by using a negative length)

SQL comes with the functions necessary to perform mathematical analysis on Integers and Real Numbers