CASE Expression
noun
say it: “KAYS ek-SPRESH-un” /keɪs ɪkˈsprɛʃən/
A SQL expression that picks a value by checking conditions in order, like an if-else inside a query.
What does CASE Expression do in a relational database?
CASE Expression — An expression that chooses a result by evaluating conditions in order.
SELECT order_id,
CASE
WHEN total_amount >= 100 THEN 'large'
ELSE 'standard'
END AS size
FROM purchase_order;
In a sentence
- “A CASE expression labels each product Cheap, Fair or Pricey.”
Level: Apprentice · More SQL terms at this level
Updated