Intermediate
SQL
Q50 / 100
What does "CASE WHEN condition THEN result ELSE other_result END" provide in a SELECT statement?
Correct! Well done.
Incorrect.
The correct answer is B) Conditional logic within a query, returning different values per row based on specified conditions, similar to if/else
B
Correct Answer
Conditional logic within a query, returning different values per row based on specified conditions, similar to if/else
Explanation
The CASE expression allows row-level conditional logic directly in SQL queries, evaluating conditions in order and returning the corresponding result.
Progress
50/100