Important SQL mathematical Functions

0
20

Find power of 10 to 5

select power(10,5)
Result
100000

Find Square root of 225

select SQRT(225)
Result
15

Select sign of a variable or value

select SIGN(-10),SIGN(10)
Result

-1 1

Find Loarithm of a value

select LOG(10)
Result
2.30258509299405

LEAVE A REPLY

Please enter your comment!
Please enter your name here