https://mp.weixin.qq.com/s?src=11×tamp=1670070823&ver=4204&signature=OpXckzt0JIEqamYo0WpJqwgtbQDMFkUpQ0Nc56WLqzHq0bMR91TRHbCxycSCx49JmQNO9K7MCZ-XLqzjJeTnSYmaGBikUZb-reachxPPf*BHipRDk8Fk0IzxBsMYpSPY&new=1
1、CASE有两种格式简单CASE函数:
case sex
when 1 then '男'
when 0 then '女'
else 其他 end
2、CASE搜索函数:
标签:case,CASE,when,SqlServer,sex,null From: https://www.cnblogs.com/Dongmy/p/16948746.htmlcase
when sex=1 then '男'
when sex=0 then '女'
else 其他 end
有null 时,用第二种。 when column is null