1.写法一
case
when uid = 1 then 1
when uid = 2 then 2
else 3
end as new_uid
2.写法二
case uid
when 1 then 1
when 2 then 2
else 3
end as new_uid
btw: case when不同条件之间是互斥的,下层的when条件肯定不满足上层所有when的条件
1.写法一
case
when uid = 1 then 1
when uid = 2 then 2
else 3
end as new_uid
2.写法二
case uid
when 1 then 1
when 2 then 2
else 3
end as new_uid
btw: case when不同条件之间是互斥的,下层的when条件肯定不满足上层所有when的条件