Array

LEN

DuckDB

Mengembalikan jumlah elemen dalam list/array. Alias dari ARRAY_LENGTH dan LENGTH untuk arrays.

Tipe hasil: BIGINTDiperbarui: 6 Jan 2026

Syntax

SQL

LEN(list)

Parameter

listLISTwajib

List/array yang akan dihitung jumlah elemennya

Contoh Penggunaan

Menghitung Elemen List

SQL

1 SELECT
2   arr,
3   LEN(arr) as element_count
4 FROM (
5   SELECT [1, 2, 3, 4, 5] as arr UNION ALL
6   SELECT ['a', 'b', 'c'] UNION ALL
7   SELECT [] UNION ALL
8   SELECT NULL
9 );

Menghitung jumlah elemen dalam berbagai list.

Hasil

arr	element_count
[1,2,3,4,5]	5
[a,b,c]	3
[]	0
NULL	NULL

Filter Berdasarkan Jumlah Tags

SQL

1 SELECT
2   article_title,
3   tags,
4   LEN(tags) as tag_count
5 FROM articles
6 WHERE LEN(tags) >= 3;

Mencari artikel dengan minimal 3 tags.

Hasil

article_title	tags	tag_count
SQL Guide	[sql,database,tutorial]	3
Python Tips	[python,data,ml,ai]	4

Aggregasi dengan List Length

SQL

1 SELECT
2   category,
3   AVG(LEN(tags)) as avg_tags,
4   MAX(LEN(tags)) as max_tags
5 FROM products
6 GROUP BY category;

Statistik jumlah tags per kategori.

Hasil

category	avg_tags	max_tags
Electronics	3.5	6
Clothing	2.8	4

Fungsi Terkait

LENGTHARRAY_LENGTH

Kembali ke DuckDB Functions

1	SELECT
2	arr,
3	LEN(arr) as element_count
4	FROM (
5	SELECT [1, 2, 3, 4, 5] as arr UNION ALL
6	SELECT ['a', 'b', 'c'] UNION ALL
7	SELECT [] UNION ALL
8	SELECT NULL
9	);

1	SELECT
2	article_title,
3	tags,
4	LEN(tags) as tag_count
5	FROM articles
6	WHERE LEN(tags) >= 3;

1	SELECT
2	category,
3	AVG(LEN(tags)) as avg_tags,
4	MAX(LEN(tags)) as max_tags
5	FROM products
6	GROUP BY category;