ABS is short name of ABSOLUTE. When we use it, it shows the absolute value of the number.
When output comes in a negetive integer, it converts it in possitive integer by multiplying it by -1.
Let's have an example:-
SELECT ABS(80);
--> 80
SELECT ABS(80.80);
--> 80.8
SELECT ABS(-80);
--> 80
SELECT ABS(-80.80);
--> 80.8
SELECT ABS(-80*10);
--> 800
SELECT ABS(80*10);
--> 800
When output comes in a negetive integer, it converts it in possitive integer by multiplying it by -1.
Let's have an example:-
SELECT ABS(80);
--> 80
SELECT ABS(80.80);
--> 80.8
SELECT ABS(-80);
--> 80
SELECT ABS(-80.80);
--> 80.8
SELECT ABS(-80*10);
--> 800
SELECT ABS(80*10);
--> 800
Read Also:- ABS function in MySql
No comments:
Post a Comment