Conditional

CASE

Snowflake

Mengevaluasi kondisi dan mengembalikan nilai berdasarkan kondisi yang terpenuhi.

Tipe hasil: Varies based on result typesDiperbarui: 6 Jan 2026

Syntax

SQL

CASE WHEN condition THEN result [WHEN ... THEN ...] [ELSE result] END

Parameter

conditionBOOLEANwajib

Kondisi untuk dievaluasi

resultanywajib

Nilai yang dikembalikan jika kondisi true

Contoh Penggunaan

Searched CASE

SQL

1 SELECT
2   product_name,
3   price,
4   CASE
5     WHEN price < 100 THEN 'Budget'
6     WHEN price < 500 THEN 'Mid-range'
7     WHEN price < 1000 THEN 'Premium'
8     ELSE 'Luxury'
9   END as category
10 FROM products;

Kategorisasi berdasarkan range harga.

Simple CASE

SQL

1 SELECT
2   status,
3   CASE status
4     WHEN 'A' THEN 'Active'
5     WHEN 'I' THEN 'Inactive'
6     WHEN 'P' THEN 'Pending'
7     ELSE 'Unknown'
8   END as status_label
9 FROM accounts;

Mapping nilai status.

Fungsi Terkait

IFFDECODE

Kembali ke Snowflake Functions

1	SELECT
2	product_name,
3	price,
4	CASE
5	WHEN price < 100 THEN 'Budget'
6	WHEN price < 500 THEN 'Mid-range'
7	WHEN price < 1000 THEN 'Premium'
8	ELSE 'Luxury'
9	END as category
10	FROM products;

1	SELECT
2	status,
3	CASE status
4	WHEN 'A' THEN 'Active'
5	WHEN 'I' THEN 'Inactive'
6	WHEN 'P' THEN 'Pending'
7	ELSE 'Unknown'
8	END as status_label
9	FROM accounts;