Math

MOD

DuckDB

Mengembalikan sisa pembagian (modulo). Bisa menggunakan fungsi MOD atau operator %.

Tipe hasil: Sama dengan tipe inputDiperbarui: 6 Jan 2026

Syntax

SQL

MOD(dividend, divisor) | dividend % divisor

Parameter

dividendnumericwajib

Angka yang dibagi

divisornumericwajib

Angka pembagi

Contoh Penggunaan

Sisa Pembagian

SQL

1 SELECT MOD(17, 5), 17 % 5;

17 dibagi 5 = 3 sisa 2.

Hasil

2, 2

Mendeteksi Genap/Ganjil

SQL

1 SELECT
2   number,
3   CASE WHEN MOD(number, 2) = 0 THEN 'Genap' ELSE 'Ganjil' END as type
4 FROM numbers;

Cek apakah angka genap atau ganjil.

Hasil

number	type
1	Ganjil
2	Genap
3	Ganjil

Alternating Row Colors

SQL

1 SELECT
2   ROW_NUMBER() OVER () as rn,
3   name,
4   CASE WHEN MOD(ROW_NUMBER() OVER (), 2) = 0 THEN 'white' ELSE 'gray' END as bg_color
5 FROM employees;

Membuat warna baris bergantian untuk display.

Cycling dengan Modulo

SQL

1 SELECT
2   month_number,
3   MOD(month_number - 1, 4) + 1 as quarter
4 FROM generate_series(1, 12) as t(month_number);

Mapping bulan ke quarter menggunakan modulo.

Fungsi Terkait

ABSSIGNPOWERSQRTCBRT

Kembali ke DuckDB Functions

1	SELECT
2	number,
3	CASE WHEN MOD(number, 2) = 0 THEN 'Genap' ELSE 'Ganjil' END as type
4	FROM numbers;

1	SELECT
2	ROW_NUMBER() OVER () as rn,
3	name,
4	CASE WHEN MOD(ROW_NUMBER() OVER (), 2) = 0 THEN 'white' ELSE 'gray' END as bg_color
5	FROM employees;

1	SELECT
2	month_number,
3	MOD(month_number - 1, 4) + 1 as quarter
4	FROM generate_series(1, 12) as t(month_number);