Math

MOD

BigQuery

Mengembalikan sisa pembagian (modulo) dari dua angka.

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

MOD(dividend, divisor)

dividendINT64/FLOAT64/NUMERICwajib

Angka yang dibagi

divisorINT64/FLOAT64/NUMERICwajib

Angka pembagi

SQL

1 SELECT
2   MOD(10, 3) as mod_result,
3   MOD(17, 5) as another_mod,
4   MOD(-10, 3) as negative_mod;

Menghitung sisa pembagian.

Hasil

mod_result	another_mod	negative_mod
1	2	-1

SQL

1 SELECT
2   row_number,
3   CASE WHEN MOD(row_number, 2) = 0 THEN 'even' ELSE 'odd' END as row_type
4 FROM `project.dataset.data`;

Menentukan baris genap/ganjil untuk styling.

1	SELECT
2	row_number,
3	CASE WHEN MOD(row_number, 2) = 0 THEN 'even' ELSE 'odd' END as row_type
4	FROM `project.dataset.data`;