Math

IEEE_DIVIDE

BigQuery

Melakukan pembagian mengikuti standar IEEE 754, mengembalikan infinity atau NaN alih-alih error.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

IEEE_DIVIDE(dividend, divisor)

Parameter

dividendFLOAT64wajib

Angka yang dibagi

divisorFLOAT64wajib

Angka pembagi

Contoh Penggunaan

IEEE Division Behavior

SQL

1 SELECT
2   IEEE_DIVIDE(10, 0) as div_by_zero,
3   IEEE_DIVIDE(-10, 0) as neg_div_by_zero,
4   IEEE_DIVIDE(0, 0) as zero_by_zero;

Perilaku pembagian IEEE untuk edge cases.

Hasil

div_by_zero	neg_div_by_zero	zero_by_zero
Infinity	-Infinity	NaN

Safe Ratio Calculation

SQL

1 SELECT
2   numerator,
3   denominator,
4   IEEE_DIVIDE(numerator, denominator) as ratio,
5   IF(IS_INF(IEEE_DIVIDE(numerator, denominator)), NULL, IEEE_DIVIDE(numerator, denominator)) as safe_ratio
6 FROM `project.dataset.ratios`;

Menghitung ratio dengan handling Infinity.

Kembali ke BigQuery Functions

1	SELECT
2	IEEE_DIVIDE(10, 0) as div_by_zero,
3	IEEE_DIVIDE(-10, 0) as neg_div_by_zero,
4	IEEE_DIVIDE(0, 0) as zero_by_zero;

1	SELECT
2	numerator,
3	denominator,
4	IEEE_DIVIDE(numerator, denominator) as ratio,
5	IF(IS_INF(IEEE_DIVIDE(numerator, denominator)), NULL, IEEE_DIVIDE(numerator, denominator)) as safe_ratio
6	FROM `project.dataset.ratios`;