[Solved] Identify the error in this Simple CASE expression:SELECT CASE WHEN Status = 1 THEN 'Active' WHEN Status = 2 THEN 'Inactive' ELSE 'Unknown' END FROM Users; | SQL

SQL - CASE Expressions

Identify the error in this Simple CASE expression:

SELECT CASE WHEN Status = 1 THEN 'Active' WHEN Status = 2 THEN 'Inactive' ELSE 'Unknown' END FROM Users;

AMissing END keyword

BIncorrect syntax: Simple CASE should not use conditions after WHEN

CELSE clause is not allowed in Simple CASE

DNo error, query is correct

Step-by-Step Solution

Solution:

Step 1: Differentiate Simple and Searched CASE
Simple CASE compares one expression to values; searched CASE uses conditions.
Step 2: Check usage of WHEN clauses
Using conditions after WHEN is for searched CASE, not Simple CASE.
Final Answer:
Incorrect syntax: Simple CASE should not use conditions after WHEN -> Option B
Quick Check:
Simple CASE uses values, not conditions [OK]

Quick Trick: Simple CASE uses values, not conditions after WHEN [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this Simple CASE expression: