Question

Which of the following is the correct syntax for a CASE statement in SQLite?

a) CASE expression WHEN value1 THEN result1 WHEN value2 THEN result2 ELSE result3 END

b) CASE expression value1 THEN result1 value2 THEN result2 ELSE result3 END

c) CASE expression WHEN value1 THEN result1 ELSE result2 END

d) None of the above

Answer 1

Answer: a) CASE expression WHEN value1 THEN result1 WHEN value2 THEN result2 ELSE result3 END

Explanation: The correct syntax for a CASE statement in SQLite is CASE expression WHEN value1 THEN result1 WHEN value2 THEN result2 ELSE result3 END.