SQL Mathematical Functions

SQL ABS Function

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

SQL CEIL (or CEILING) and FLOOR functions are using to round the numbers.

SQL POWER function returns the raised to the power of .

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

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

SQL SQRT function extracts the square root from the positive numeric input argument.

SQL PI function returns a constant value of pi.

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

SQL LOG function allows us to operate mathematical logarithmic calculation.

SQL trigonometric functions allow you to operate trigonometric calculations like sine, cosine, tangent...