* Question
| What should I pay attention to when using CASE statements? |
* Answer
| First, the value represented by the selection value or identifier in the WHEN condition must be within the range of the expression.Second, the selection value in the CASE statement can only appear once, and the conditional statement with the same selection value cannot appear.Third, the CASE statement must be selected for execution and only one of the listed conditions can be selected. |
COMMENTS