Math

MOD

Snowflake

Mengembalikan sisa pembagian (modulo).

Tipe hasil: Same as inputDiperbarui: 6 Jan 2026

Syntax

SQL

MOD(dividend, divisor)

dividendnumericwajib

Angka yang dibagi

divisornumericwajib

Pembagi

SQL

1 SELECT MOD(17, 5) as result;

Sisa 17 dibagi 5.

Hasil

SQL

1 SELECT
2   number,
3   CASE WHEN MOD(number, 2) = 0 THEN 'Even' ELSE 'Odd' END as parity
4 FROM numbers;

Mengecek genap atau ganjil.

1	SELECT
2	number,
3	CASE WHEN MOD(number, 2) = 0 THEN 'Even' ELSE 'Odd' END as parity
4	FROM numbers;