[Solved] Identify the error in this SQL snippet using CASE:SELECT Name, CASE Salary > 5000 THEN 'High' ELSE 'Low' END AS SalaryLevel FROM Employees; | SQL

SQL - CASE Expressions

Identify the error in this SQL snippet using CASE:

SELECT Name, CASE Salary > 5000 THEN 'High' ELSE 'Low' END AS SalaryLevel FROM Employees;

AMissing WHEN keyword after CASE

BMissing END keyword at the end

CIncorrect alias usage for SalaryLevel

DCASE cannot be used in SELECT clause

Step-by-Step Solution

Solution:

Step 1: Review CASE syntax
CASE must be followed by WHEN condition THEN result; here WHEN is missing.
Step 2: Check other parts
END keyword is present; alias usage is correct; CASE is valid in SELECT.
Final Answer:
Missing WHEN keyword after CASE -> Option A
Quick Check:
CASE requires WHEN after CASE [OK]

Quick Trick: CASE always needs WHEN after it [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 SQL snippet using CASE: