login

SQL Mathematical Functions

SQL CEIL() (or CEILING) and FLOOR() Functions

Both SQL CEIL(or CEILING) and FLOOR functions are round the numbers. SQL CEIL roundup to the nearest integer value while FLOOR round down to the next least integer value.

SQL RAND Function

The SQL RAND() function is used to generate some random numbers at run time.

SQL ABS Function

SQL ABS function returns the absolute value of an numeric input argument.

SQL EXP Function

The SQL EXP() function returns e raised to the n-th power (e is the base of the natural logarithm and is equal to approximately 2.718281828459).

SQL PI Function

SQL PI() function maybe the most simplest mathematical SQL function because it returns a constant value of pi

SQL SQRT Function

The SQL SQRT function extracts the square root from the positive numeric input argument. SQL SQRT function accepts only positive arguments, and returns an error when a negative argument is passed in.

SQL POWER Function

The SQL POWER() function returns the

SQL ROUND Function

The SQL ROUND function rounds a number to a specific length or precision.

SQL LOG Function

The SQL LOG() function allows us to operate mathematical logarithmic calculation

SQL Trigonometric Functions

SQL trigonometric functions allow you to operates trigonometric calculations.Here are some common SQL trigonometric functions you need to know in your daily SQL programming.