SQL - CASE Expressions
Which keyword is mandatory to end a searched CASE expression in SQL?
Which keyword is mandatory to end a searched CASE expression in SQL?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Recall searched CASE syntax
A searched CASE expression starts with CASE and must end with END.Step 2: Identify the correct ending keyword
The keyword END marks the end of the CASE expression.Final Answer:
END -> Option BQuick Check:
CASE ends with END keyword [OK]
Quick Trick: Always close CASE with END keyword [OK]
Common Mistakes:
- Using FINISH or STOP instead of END
- Omitting the END keyword
- Confusing END with ELSE
Master "CASE Expressions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes