Aggregate

MODE

PostgreSQL

Mengembalikan nilai yang paling sering muncul (modus) dari sekumpulan data. Jika ada beberapa nilai dengan frekuensi sama, mengembalikan yang pertama berdasarkan ORDER BY.

Tipe hasil: same as input

Syntax

SQL

MODE() WITHIN GROUP (ORDER BY expression)

Parameter

expressionany orderablewajib

Kolom yang akan dicari modusnya

Contoh Penggunaan

Modus Sederhana

SQL

1 SELECT 
2   MODE() WITHIN GROUP (ORDER BY category) AS most_common_category
3 FROM products;

Mencari kategori produk yang paling banyak.

Hasil

most_common_category
Electronics

Modus per Grup

SQL

1 SELECT 
2   store_id,
3   MODE() WITHIN GROUP (ORDER BY product_id) AS best_seller
4 FROM sales
5 GROUP BY store_id;

Mencari produk terlaris per toko.

Hasil

store_id	best_seller
1	101
2	205

Rating Paling Umum

SQL

1 SELECT 
2   product_id,
3   MODE() WITHIN GROUP (ORDER BY rating) AS typical_rating,
4   AVG(rating) AS avg_rating
5 FROM reviews
6 GROUP BY product_id;

Membandingkan modus rating dengan rata-rata.

Fungsi Equivalen di Database Lain

MODE

Snowflake

MODE

DuckDB

Fungsi Terkait

STDDEVVARIANCECORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISC

Kembali ke PostgreSQL Functions

1	SELECT
2	MODE() WITHIN GROUP (ORDER BY category) AS most_common_category
3	FROM products;

1	SELECT
2	store_id,
3	MODE() WITHIN GROUP (ORDER BY product_id) AS best_seller
4	FROM sales
5	GROUP BY store_id;

1	SELECT
2	product_id,
3	MODE() WITHIN GROUP (ORDER BY rating) AS typical_rating,
4	AVG(rating) AS avg_rating
5	FROM reviews
6	GROUP BY product_id;