Aggregate

MODE

Snowflake

Mengembalikan nilai yang paling sering muncul (modus) dalam sebuah grup. Berguna untuk menemukan nilai yang paling umum.

Tipe hasil: Same as input typeDiperbarui: 6 Jan 2026

Syntax

SQL

MODE(expression)

Parameter

expressionanywajib

Kolom atau ekspresi yang akan dicari modusnya

Contoh Penggunaan

Produk Paling Laris

SQL

1 SELECT MODE(product_id) as most_ordered_product
2 FROM orders
3 WHERE order_date >= '2024-01-01';

Mencari produk yang paling sering dipesan.

Hasil

PROD-123

Mode per Kategori

SQL

1 SELECT
2   category,
3   MODE(brand) as most_common_brand,
4   COUNT(*) as total_products
5 FROM products
6 GROUP BY category;

Mencari brand paling umum di setiap kategori produk.

Hasil

CATEGORY	MOST_COMMON_BRAND	TOTAL_PRODUCTS
Electronics	Samsung	250
Clothing	Nike	180
Books	Penguin	320

Payment Method Favorit

SQL

1 SELECT
2   customer_segment,
3   MODE(payment_method) as preferred_payment
4 FROM orders o
5 JOIN customers c ON o.customer_id = c.id
6 GROUP BY customer_segment;

Mencari metode pembayaran yang paling sering digunakan per segment customer.

Fungsi Terkait

STDDEVSTDDEV_POPSTDDEV_SAMPVARIANCEVAR_POPVAR_SAMPCORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISCMEDIAN

Kembali ke Snowflake Functions

1	SELECT MODE(product_id) as most_ordered_product
2	FROM orders
3	WHERE order_date >= '2024-01-01';

1	SELECT
2	category,
3	MODE(brand) as most_common_brand,
4	COUNT(*) as total_products
5	FROM products
6	GROUP BY category;

1	SELECT
2	customer_segment,
3	MODE(payment_method) as preferred_payment
4	FROM orders o
5	JOIN customers c ON o.customer_id = c.id
6	GROUP BY customer_segment;