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