Which of the following statements is True?
A) The WHEN clause of a CASE statement ends with a semicolon.
B) The WHEN clause of a CASE statement ends with "END CASE;".
C) The WHEN clause of a CASE expression does not end with a semicolon.
D) The WHEN clause of a CASE statement ends with "ENDCASE".

Question

Quizplus · Accepted Answer

The WHEN clause of a CASE expression does not end with a semicolon. In SQL, the syntax for a CASE expression is as follows:

CASE
   WHEN condition1 THEN result1
   WHEN condition2 THEN result2
   ...
   WHEN conditionN THEN resultN
   ELSE default_result
END

Each WHEN clause has the keyword "WHEN" followed by a condition and then the corresponding result. The last WHEN clause ends with the result value and the expression is closed with the "END" keyword. There is no semicolon at the end of the WHEN clause.

Which of the Following Statements Is True