[Solved] Which of the following is the correct syntax to use CASE inside an ORDER BY clause? — Ans: ORDER BY CASE WHEN condition THEN value ELSE value END | SQL

SQL - CASE Expressions

Which of the following is the correct syntax to use CASE inside an ORDER BY clause?

AORDER BY CASE WHEN condition THEN value ELSE value END

BORDER BY IF condition THEN value ELSE value END

CORDER BY SWITCH condition THEN value ELSE value END

DORDER BY SELECT CASE condition THEN value ELSE value END

Step-by-Step Solution

Solution:

Step 1: Recall correct CASE syntax in ORDER BY
The correct syntax uses CASE WHEN ... THEN ... ELSE ... END without extra keywords.
Step 2: Identify incorrect keywords
Options A, B, and C use invalid keywords like SELECT, IF, or SWITCH which are not valid in ORDER BY CASE.
Final Answer:
ORDER BY CASE WHEN condition THEN value ELSE value END -> Option A
Quick Check:
CASE syntax = WHEN THEN ELSE END [OK]

Quick Trick: Use CASE WHEN ... THEN ... ELSE ... END in ORDER BY [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax to use CASE inside an ORDER BY clause?