ABS Function in SQL

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(20);

-->20

SELECT ABS(20.20);

-->20.2

SELECT ABS(-10);

-->10

SELECT ABS(-10.10);

--> 10.1

SELECT ABS(-20*20);

--> 400

SELECT ABS(20*20);

--> 400


Read Also:-  ABS function in Oracle