SUBTRACT

All functions > MATH > SUBTRACT

Returns the result of the subtraction of the second number from the first.

Signatures

Numeric subtraction

Returns: the result of the subtraction

SUBTRACT(number1: T, number2: T) → T

With:

• T : Any numeric type

Notes

• Both arguments must be of the same numeric type
• Returns NULL if either operand is NULL
• Order matters: SUBTRACT(a, b) ≠ SUBTRACT(b, a)
• Operator form: number1 - number2

See also

• Operators1

Examples

SELECT
    f1 := SUBTRACT(10, 3),  -- Basic subtraction
    f2 := SUBTRACT(5, 5),  -- Equal numbers
    f3 := SUBTRACT(1, 7),  -- Negative result
    f4 := SUBTRACT(0, -5)  -- Subtracting negative
;