Math

SAFE_DIVIDE

BigQuery

Melakukan pembagian aman yang mengembalikan NULL alih-alih error saat pembagi nol.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

SAFE_DIVIDE(dividend, divisor)

dividendFLOAT64/INT64/NUMERICwajib

Angka yang dibagi

divisorFLOAT64/INT64/NUMERICwajib

Angka pembagi

SQL

1 SELECT
2   SAFE_DIVIDE(10, 2) as normal_div,
3   SAFE_DIVIDE(10, 0) as div_by_zero,
4   10 / NULLIF(0, 0) as traditional_way;

Perbandingan SAFE_DIVIDE dengan pendekatan tradisional.

Hasil

normal_div	div_by_zero	traditional_way
5.0	NULL	NULL

SQL

1 SELECT
2   campaign,
3   conversions,
4   clicks,
5   SAFE_DIVIDE(conversions, clicks) * 100 as conversion_rate
6 FROM `project.dataset.campaigns`;

Menghitung conversion rate tanpa khawatir zero clicks.

1	SELECT
2	campaign,
3	conversions,
4	clicks,
5	SAFE_DIVIDE(conversions, clicks) * 100 as conversion_rate
6	FROM `project.dataset.campaigns`;