[Solved] Find the error in this query:SELECT * FROM Sales WHERE CASE WHEN region = 'North' THEN amount > 1000 ELSE amount < 500 END = TRUE; | SQL

SQL - CASE Expressions

Find the error in this query:

SELECT * FROM Sales WHERE CASE WHEN region = 'North' THEN amount > 1000 ELSE amount < 500 END = TRUE;

AIncorrect use of comparison operator inside CASE

BMissing ELSE clause in CASE

CCASE cannot be used in WHERE clause

DIncorrect comparison of CASE result with TRUE

Step-by-Step Solution

Solution:

Step 1: Understand CASE returns boolean
CASE returns TRUE or FALSE based on conditions.
Step 2: Check comparison with TRUE
Comparing CASE result with TRUE is redundant and may cause errors.
Step 3: Correct usage
Use CASE directly in WHERE without '= TRUE'.
Final Answer:
Incorrect comparison of CASE result with TRUE -> Option D
Quick Check:
Use CASE directly in WHERE without '= TRUE' [OK]

Quick Trick: Don't compare CASE result to TRUE in WHERE [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the error in this query: