[Solved] What will be the output of this query?SELECT ProductID, CASE CategoryID WHEN 10 THEN 'Electronics' WHEN 20 THEN 'Clothing' END AS CategoryName FROM Products;If CategoryID is 30 for some rows. | SQL

SQL - CASE Expressions

What will be the output of this query?

SELECT ProductID, CASE CategoryID WHEN 10 THEN 'Electronics' WHEN 20 THEN 'Clothing' END AS CategoryName FROM Products;

If CategoryID is 30 for some rows.

ACategoryName will be 'Clothing' for CategoryID 30

BCategoryName will be 'Electronics' for CategoryID 30

CCategoryName will be NULL for CategoryID 30

DQuery will fail with syntax error

Step-by-Step Solution

Solution:

Quick Trick: No ELSE means unmatched CASE returns NULL [OK]

Common Mistakes:

Master "CASE Expressions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?