Case expression
Bucket values.
- Snippet
- SQL
- 7 blanks to fill
SELECT Column,
CASE
WHEN Condition 1 THEN 'Label 1'
WHEN Condition 2 THEN 'Label 2'
ELSE 'Other'
END AS bucket
FROM Table; Orange words are blanks you have not filled yet. Press ⌘ Return to copy.
About this template
Bucket values.
- Category
- Code snippets
- Pack
- SQL
- Type
- Snippet, a short message
- Asks for
- Column, Condition 1, Label 1, Condition 2, Label 2, Other, Table
Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.
Template source
The template as written, with its blanks in double braces, such as {{Name}}.
SELECT {{Column}},
CASE
WHEN {{Condition 1}} THEN '{{Label 1}}'
WHEN {{Condition 2}} THEN '{{Label 2}}'
ELSE '{{Other}}'
END AS bucket
FROM {{Table}};