[Solved] Identify the error in this SQL query:SELECT name FROM Employees ORDER BY CASE WHEN department = 'Sales' THEN 1 WHEN department = 'HR' THEN 2 ELSE 3; | SQL

SQL - CASE Expressions

Identify the error in this SQL query:

SELECT name FROM Employees ORDER BY CASE WHEN department = 'Sales' THEN 1 WHEN department = 'HR' THEN 2 ELSE 3;

AORDER BY cannot use CASE statements.

BIncorrect use of ELSE in CASE.

CMissing END keyword to close CASE statement.

DMissing THEN keyword after conditions.

Step-by-Step Solution

Solution:

Step 1: Check CASE syntax completeness
The CASE statement must end with the keyword END to close it.
Step 2: Identify missing END keyword
The query lacks END after ELSE 3, causing syntax error.
Final Answer:
Missing END keyword to close CASE statement. -> Option C
Quick Check:
CASE must end with END [OK]

Quick Trick: Always close CASE with END keyword [OK]

Common Mistakes:

Omitting END keyword
Misplacing ELSE clause
Thinking CASE not allowed in ORDER BY

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Identify the error in this SQL query:

Step 1: Check CASE syntax completeness

Step 2: Identify missing END keyword

Final Answer:

Quick Check:

Want More Practice?