close
1. CASE WHEN expression1 THEN VALUE_1
WHEN expression2 THEN VALUE_2
ELSE VALUE_N
END AS NEW_FIELD
2. CASE Paramter
WHEN CONDITION_VALUE_1 THNE VALUE_1
WHEN CONDITION_VALUE_2 THNE VALUE_2
ELSE VALUE_N
END AS NEW_FIELD
[參考]
https://blog.csdn.net/wangjolly/article/details/85274322
文章標籤
全站熱搜
留言列表
{{ article.title }}