Mathematical Functions

Function	Purpose	Syntax
`ABS()`	Returns absolute value	`ABS ( numeric_expression )`
`CEILING()`	Returns smallest integer greater than or equal to the number	`CEILING ( numeric_expression )`
`FLOOR()`	Returns largest integer less than or equal to the number	`FLOOR ( numeric_expression )`
`ROUND()`	Rounds a number to specified decimal places	`ROUND ( numeric_expression , length [ ,function ] )`
`POWER()`	Returns value raised to a specified power	`POWER ( numeric_expression , power_expression )`
`SQRT()`	Returns square root	`SQRT ( numeric_expression )`
`LOG()`	Returns natural logarithm	`LOG ( numeric_expression )`
`LOG10()`	Returns base‑10 logarithm	`LOG10 ( numeric_expression )`
`EXP()`	Returns e raised to the power of the argument	`EXP ( numeric_expression )`
`SIGN()`	Returns sign of the number	`SIGN ( numeric_expression )`
`PI()`	Returns the constant π	`PI ()`

Examples

SELECT ABS(-15) AS AbsoluteValue;   -- Returns 15
SELECT CEILING(22.3) AS CeilValue;   -- Returns 23
SELECT FLOOR(22.9) AS FloorValue;    -- Returns 22
SELECT ROUND(123.4567, 2) AS Rounded;-- Returns 123.46
SELECT POWER(2,8) AS PowerResult;    -- Returns 256
SELECT SQRT(144) AS SqrtResult;      -- Returns 12
SELECT LOG(10) AS NaturalLog;        -- Returns 2.302585...
SELECT LOG10(1000) AS Log10Result;   -- Returns 3
SELECT EXP(1) AS ExpResult;          -- Returns 2.71828...
SELECT SIGN(-8) AS SignResult;       -- Returns -1
SELECT PI() AS PiValue;              -- Returns 3.1415926535...