SQL Mathematical 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.
The SQL RAND() function is used to generate some random numbers at run time.
SQL ABS function returns the absolute value of an numeric input argument.
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 maybe the most simplest mathematical SQL function because it returns a constant value of pi
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.
The SQL POWER() function returns the
The SQL ROUND function rounds a number to a specific length or precision.
The SQL LOG() function allows us to operate mathematical logarithmic calculation
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.