[Solved] Identify the error in this query using CASE in WHERE clause:SELECT * FROM Orders WHERE CASE order_status WHEN 'shipped' THEN TRUE ELSE FALSE; | SQL

SQL - CASE Expressions

Identify the error in this query using CASE in WHERE clause:

SELECT * FROM Orders WHERE CASE order_status WHEN 'shipped' THEN TRUE ELSE FALSE;

AMissing END keyword for CASE expression

BIncorrect use of TRUE/FALSE in CASE

CCASE cannot be used in WHERE clause

DMissing THEN keyword in CASE

Step-by-Step Solution

Solution:

Step 1: Check CASE syntax completeness
The CASE expression must end with END keyword, which is missing here.
Step 2: Verify other parts
TRUE/FALSE usage is valid, CASE can be used in WHERE, and THEN keyword is present.
Final Answer:
Missing END keyword for CASE expression -> Option A
Quick Check:
CASE ... END required [OK]

Quick Trick: Always close CASE with END in WHERE [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 query using CASE in WHERE clause: