[Solved] Find the error in this SQL query:SELECT student_name FROM Students ORDER BY CASE student_name WHEN 'John' THEN 1 WHEN 'Jane' THEN 2 ELSE 3 | SQL

SQL - CASE Expressions

Find the error in this SQL query:

SELECT student_name FROM Students ORDER BY CASE student_name WHEN 'John' THEN 1 WHEN 'Jane' THEN 2 ELSE 3

AIncorrect column name used in ORDER BY

BMissing END keyword to close the CASE expression

CCASE cannot be used in ORDER BY clause

DTHEN values must be strings, not numbers

Step-by-Step Solution

Solution:

Quick Trick: Always close CASE with END [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 SQL query: