abs functions
We can get absolute value by using abs function. This function takes one numeric input data. Here is an example
select abs(2.3)
Output of above code is 2.3
select abs(+4.567)
Ouput is 4.567
select abs(0.23)
It is 0.23
Getting the sign of the number by using sign function
We can get the sign of the data by using sign function. Here is an example
select sign(4.5); Output 1
select sign(+4.5); Output 1
select sign(4.5); Output 1
If we try a sting we will get 0 as output
select sign('abc'); // Output 0
What is the output of sign(0) ?
Be the first to post comment on this article :
More on Math functions in SQL 

 


