|
It perform a calculation, usually based on input
values and return a numeric value.
Below is All built-in Sql Mathematic Function :
ABS,
DEGREES, RAND,
ACOS, EXP,
ROUND, ASIN,
FLOOR, SIGN,
ATAN, LOG,
SIN, ATN2,
LOG10, SQUARE,
CEILING, PI,
SQRT, COS,
POWER, TAN,
COT,
RADIANS
Example SQL Mathematic Functions -
ABS
- Returns the absolute and positive value.
Syntax - ABS (
numeric )
SELECT
ABS(-1.0) -- Value = 1.0
SELECT ABS(0.0) -- Value =
0.0
SELECT ABS(1.0) -- Value =
1.0
Example SQL Mathematic Functions -
DEGREES
- returns angle in degrees from radian value.
Syntax - DEGREES( numeric)
SELECT DEGREES(1) -- Value =
57 degrees
SELECT DEGREES(2) -- Value =
114 degrees
Example SQL Mathematic Functions -
FLOOR
- Returns the largest integer less than or equal to
the given numeric expression.
Syntax - FLOOR( numeric)
SELECT FLOOR(32.15)
-- Value = 32
SELECT FLOOR(-32.15)
-- Value = -33
SELECT FLOOR($32.15)
-- Value = 32.0000
Example SQL Mathematic Functions -
CEILING
- Returns the smallest integer
greater than, or equal to the input value
Syntax -
CEILING( numeric)
SELECT CEILING(32.15) -- Value =
33
SELECT CEILING(-32.15) -- Value =
-32
SELECT CEILING($32.15) -- Value =
33.0000
Example SQL Mathematic Functions -
ROUND
- Return rounded value.
Syntax -
ROUND( numeric, length)
SELECT ROUND(32.15 ,1)
-- Value = 32.20
SELECT ROUND(32.14 ,1)
-- Value = 32.10
SELECT ROUND(32.14998
,4) -- Value = 32.15000
SELECT ROUND(32.14992
,4) -- Value = 32.14990
SELECT ROUND(32.92 ,0)
-- Value = 33.00
Example SQL Mathematic Functions -
POWER
- Returns the value of input to the
specified power.
Syntax - POWER( numeric,
power(integer))
SELECT POWER(6,2)
-- Value = 36 (6*6)
SELECT POWER(9,3)
-- Value = 729 (9*9*9)
powered by www.pHick1.com
|
|