Searched CASE

Write the searched form of CASE.

Searched CASE takes an independent condition in each WHEN. It is the most flexible CASE form.

SELECT name,
  CASE WHEN price < 50 THEN 'ucuz'
       WHEN price < 200 THEN 'orta'
       ELSE 'pahalı' END AS tier
FROM products;

This query produces three price tiers.

name, CASE WHEN price < 50 THEN 'ucuz' WHEN price < 200 … is selected from products.

Searched CASE — details

In searched CASE each WHEN holds a separate boolean condition. The first true condition's THEN runs.

Conditions are tried from top to bottom, so WHEN price < 50 must come before WHEN price < 100, otherwise the first one never runs.

Write a three-tier CASE WHEN price < 50 THEN 'ucuz' WHEN price < 200 THEN 'orta' ELSE 'pahalı' END.

Show example solution

SELECT name,
  CASE WHEN price < 50 THEN 'ucuz'
       WHEN price < 200 THEN 'orta'
       ELSE 'pahalı' END AS tier
FROM products;

Add WHEN

CASE ____ price < 50 THEN 'ucuz'

Show answer

CASE WHEN price < 50 THEN 'ucuz'

Next lesson: Simple CASE