[Solved] Find the error in this nested CASE expression:SELECT CASE WHEN Marks > 75 THEN CASE WHEN Marks > 90 THEN 'Distinction' ELSE 'Pass' END ELSE 'Fail' FROM Students; | SQL

SQL - CASE Expressions

Find the error in this nested CASE expression:

SELECT CASE WHEN Marks > 75 THEN CASE WHEN Marks > 90 THEN 'Distinction' ELSE 'Pass' END ELSE 'Fail' FROM Students;

AIncorrect comparison operator used

BMissing END keyword for the outer CASE expression

CELSE clause is not allowed in nested CASE

DCASE expressions cannot be nested

Step-by-Step Solution

Solution:

Step 1: Check CASE syntax
Every CASE expression must end with an END keyword.
Step 2: Analyze given query
The inner CASE has END, but the outer CASE lacks its END keyword.
Final Answer:
Missing END keyword for the outer CASE expression -> Option B
Quick Check:
Each CASE needs matching END [OK]

Quick Trick: Every CASE requires END keyword [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 nested CASE expression: