ABS

Take the absolute value of a number.

ABS returns the absolute value of a number; it makes negatives positive.

SELECT ABS(balance) AS mutlak FROM accounts;

This query returns the positive form of a negative balance.

ABS(balance) AS mutlak is selected from accounts.

ABS — details

ABS(-5) = 5, ABS(5) = 5. It is used to show debt values as positive in balance calculations.

Select the absolute value of balance aliased as mutlak from accounts.

Show example solution

SELECT ABS(balance) AS mutlak
FROM accounts

Absolute value

SELECT ____(balance) FROM accounts;

Show answer

SELECT ABS(balance) FROM accounts;