Conditional

DECODE

Snowflake

Mencocokkan expr dengan search values dan mengembalikan result yang sesuai (Oracle-style CASE).

Tipe hasil: Common type of resultsDiperbarui: 6 Jan 2026

Syntax

SQL

DECODE(expr, search1, result1, [search2, result2, ...], [default])

Parameter

expranywajib

Expression untuk dicocokkan

searchanywajib

Nilai yang dicari

resultanywajib

Nilai yang dikembalikan jika cocok

defaultanyopsional

Nilai jika tidak ada yang cocok

Contoh Penggunaan

Value Mapping

SQL

1 SELECT
2   status_code,
3   DECODE(status_code, 1, 'Active', 2, 'Inactive', 3, 'Pending', 'Unknown') as status
4 FROM accounts;

Mapping kode status ke label.

Day Name

SQL

1 SELECT DECODE(DAYOFWEEK(order_date),
2   0, 'Sunday', 1, 'Monday', 2, 'Tuesday',
3   3, 'Wednesday', 4, 'Thursday', 5, 'Friday',
4   6, 'Saturday') as day_name
5 FROM orders;

Konversi nomor hari ke nama.

Fungsi Terkait

CASEIFFTO_BINARY

Kembali ke Snowflake Functions

1	SELECT
2	status_code,
3	DECODE(status_code, 1, 'Active', 2, 'Inactive', 3, 'Pending', 'Unknown') as status
4	FROM accounts;

1	SELECT DECODE(DAYOFWEEK(order_date),
2	0, 'Sunday', 1, 'Monday', 2, 'Tuesday',
3	3, 'Wednesday', 4, 'Thursday', 5, 'Friday',
4	6, 'Saturday') as day_name
5	FROM orders;