ABS Function in MySql

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

--> 30

SELECT ABS(30.30);

--> 30.3

SELECT ABS(-30);

--> 30

SELECT ABS(-30.30);

--> 30.3

SELECT ABS(-30*30);

--> 900

SELECT ABS(30*30);

--> 900


Read Also:-  ABS function in MariaDB