PostgreSQLNumeric FunctionsABS
MD5

ABSNumeric Functions

CEIL

Returns the absolute value.

Syntax

ABS(x)

Example

Enter values below to update the example in real time.

order_id
expected_qty
actual_qty
qty_diff
inventory_log
SELECT order_id, ABS(expected_qty - actual_qty) AS qty_diff
FROM inventory_log;