Answer
CASE is a conditional SQL expression that returns one result from matching branches. • A searched CASE evaluates Boolean WHEN conditions. • A simple CASE compares one expression with several values. • If no branch matches, ELSE is returned or NULL when ELSE is absent.
💡 SQL Example
SELECT name,
CASE WHEN salary >= 60000 THEN 'Senior' ELSE 'Standard' END AS level
FROM employees;
Result
Maya | Senior
⚡ Quick Revision
CASE chooses a value from ordered conditions.