How does CASE work?

SQL SELECT, filtering and sorting · Freshers and experienced

Model answer

CASE adds if-else logic inside a query: CASE WHEN score >= 90 THEN 'A' WHEN score >= 75 THEN 'B' ELSE 'C' END. It works in SELECT, ORDER BY and inside aggregates, such as SUM(CASE WHEN status = 'paid' THEN amount ELSE 0 END).

Learn this topic

SELECT, FROM and WHERE: Your First Queries in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• How do you select specific columns and filter rows?
• How do you combine conditions in WHERE?
• What does LIKE do, and what are % and _?
• How do you sort and limit results?
• What does DISTINCT do?
• What is an alias?