SQL - CASE Expressions
What will be the output of this query?
SELECT CASE WHEN 5 < 3 THEN 'Yes' WHEN 5 > 3 THEN 'No' ELSE 'Maybe' END AS Result;
What will be the output of this query?
medium📝 query result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Evaluate conditions in order
First condition: 5 < 3 is false. Second condition: 5 > 3 is true.Step 2: Determine returned value
Since second condition is true, CASE returns 'No'.Final Answer:
'No' -> Option AQuick Check:
First true condition result = 'No' [OK]
Quick Trick: CASE returns first true condition's result [OK]
Common Mistakes:
- Choosing first condition without checking truth
- Assuming ELSE runs if any condition is true
- Confusing output with NULL
Master "CASE Expressions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes