Math

SAFE_SUBTRACT

BigQuery

Melakukan pengurangan aman yang mengembalikan NULL jika overflow.

Tipe hasil: Same as inputDiperbarui: 7 Jan 2026

Syntax

SQL

SAFE_SUBTRACT(x, y)

xINT64/NUMERIC/BIGNUMERICwajib

Operand pertama

yINT64/NUMERIC/BIGNUMERICwajib

Operand kedua

SQL

1 SELECT
2   SAFE_SUBTRACT(-9223372036854775808, 1) as might_overflow,
3   SAFE_SUBTRACT(500, 200) as normal_sub;

Pengurangan dengan handling overflow.

Hasil

might_overflow	normal_sub
NULL	300

1	SELECT
2	SAFE_SUBTRACT(-9223372036854775808, 1) as might_overflow,
3	SAFE_SUBTRACT(500, 200) as normal_sub;