Mathematical functions of SQL functions

1.ABS:
Function: Returns the absolute value of a given number

SELECT ABS (A) absolute_value from NUMBERS;

2.CEIL and Floor:
Function: Cell returns the smallest integer equal to or greater than the given parameter
Floor returns the largest integer equal to or smaller than the given parameter

SELECT B,ceil (B) CEILING from NUMBERS;
SELECT A,floor (A) floor from NUMBERS;

3.cos,cosh,sin,sinh,tan,tanh
Function: The Cos,sin,tan function can return the trigonometric function value of a given parameter, and the default parameter is determined to be the radian system.
4.EXP
Function: Returns a power value that is an exponent of the given parameter and a base of E.
5.LN and LOG
function: Two logarithmic functions where LN returns the natural logarithm of a given parameter
Log requires two parameters, where the second parameter is the base
SELECT B,log (b,10) from NUMBERS;

6.MOD
function: modulo (remainder) operation

SELECT A,b,mod (A, b) from NUMBERS;

7.POWER
Function: Returns the power of one number to another
The first argument is the base when using the power function, the second is the exponent

SELECT A,ceil (b), POWER (A,ceil (b)) from NUMBERS;

8.SIGN (flag function)
Function: If the value of the parameter is negative, then sign returns-1
If the value of the parameter is positive, sign returns 1
If the argument is zero, sign also returns zero

SELECT a,sign (A) from NUMBERS;

9.SQRT
Function: Returns the square root of a parameter

SELECT a,sqrt (A) from NUMBERS;

Mathematical functions of SQL functions