Aggregate

MODE

DuckDB

Mengembalikan nilai yang paling sering muncul (modus) dalam sebuah kolom.

Tipe hasil: Sama dengan tipe inputDiperbarui: 6 Jan 2026

Syntax

SQL

MODE(expression)

expressionanywajib

Kolom atau ekspresi yang akan dicari modusnya

SQL

1 SELECT MODE(category) as most_common_category
2 FROM orders;

Mencari kategori produk yang paling sering dipesan.

Hasil

Electronics

SQL

1 SELECT
2   region,
3   MODE(payment_method) as preferred_payment,
4   COUNT(*) as total_orders
5 FROM orders
6 GROUP BY region;

Mencari metode pembayaran paling populer per region.

Hasil

region	preferred_payment	total_orders
Jakarta	Credit Card	5230
Surabaya	Bank Transfer	3120

1	SELECT
2	region,
3	MODE(payment_method) as preferred_payment,
4	COUNT(*) as total_orders
5	FROM orders
6	GROUP BY region;