SQL - EXP()
Exponential is a mathematical function
which is almost always understood to mean the natural exponential function. The
function EXP() returns the exponential value for the numeric expression. I have
come across the EXP built in function in SQL Server and this function plays a
very important role in data analytics calculations.
This function has one mandatory argument
and it returns float type exponential value. In SQL, we have use the following
syntax:
SQL Syntax: EXP(Argument)
Argument: Any numeric
expression.
Return Type: float.
Note: If value is numeric
and not equal to zero then it will return float type otherwise it will return
1 for the 0 value. if argument is null then return type should be null.
|
The exponential function is equal to ex. The value for the constant float number e is approximately
2.718281828 (natural logarithm).
----- declare local veriables
declare @inpfloat float=1.2,
@inpInt INT=1,
@inpDecimal Decimal=1.2
----- output parameters
select EXP(@inpfloat) as 'Float EXP()',
EXP(@inpINT) as
'Int EXP()',
EXP(@inpDecimal) as 'Decimal EXP()'
---- set value 0 for veriable
SET @inpfloat=0
SET @inpInt=0
SET @inpDecimal=0
----- output parameters
select EXP(@inpfloat) as 'Float EXP()',
EXP(@inpINT) as
'Int EXP()',
EXP(@inpDecimal) as 'Decimal EXP()'
We can view the
difference on the above results. this is because 0 is to
the power anything is equal to 1.
|
Conclusion
In simple words EXP() function is used to
get the value of e ^ x because Exp expects a float and returns one, so the
results from a decimal type include an implicit conversion to and from float
and in turn this behaviour is due to inherent imprecision of FP numbers.
This comment has been removed by the author.
ReplyDeleteYou have shared a nice blog about sql data expo thanks for sharing this information with us. Taylor Swift Red Cardigan
ReplyDelete