Array

UNNEST

DuckDB

Mengekspansi list menjadi baris-baris terpisah. Sangat powerful untuk analisis data nested.

Tipe hasil: Table (rows)Diperbarui: 6 Jan 2026

Syntax

SQL

UNNEST(list) | UNNEST(list, recursive := true)

listLISTwajib

List yang akan di-unnest

recursiveBOOLEANopsional

Unnest nested list secara rekursif

Default: false

SQL

1 SELECT UNNEST([1, 2, 3, 4, 5]) AS number;

Mengekspansi list menjadi 5 baris.

Hasil

1 2 3 4 5

SQL

1 SELECT
2   product_name,
3   UNNEST(tags) AS tag
4 FROM products;

Setiap tag menjadi baris terpisah.

SQL

1 SELECT
2   UNNEST(['a', 'b', 'c']) AS letter,
3   UNNEST([1, 2, 3]) AS number;

UNNEST parallel untuk multiple lists.

Hasil

a,1 | b,2 | c,3

SQL

1 SELECT
2   tag,
3   COUNT(*) AS usage_count
4 FROM products, UNNEST(tags) AS t(tag)
5 GROUP BY tag
6 ORDER BY usage_count DESC;

Menghitung frekuensi setiap tag.

UNNEST

PostgreSQL

FLATTEN

Snowflake

UNNEST

BigQuery

1	SELECT
2	tag,
3	COUNT(*) AS usage_count
4	FROM products, UNNEST(tags) AS t(tag)
5	GROUP BY tag
6	ORDER BY usage_count DESC;