–简单Case函数
case sex
when ‘1’ then ‘男孩’
when ‘2’ then ‘女孩’
else ’ 其他’ end
–Case 搜索函数
case when sex = ‘1’ then ‘男’
when sex = ‘2’ then ‘女’
else ‘其他’ end
oracle case...when..then用法
最新推荐文章于 2024-07-24 20:04:27 发布
–简单Case函数
case sex
when ‘1’ then ‘男孩’
when ‘2’ then ‘女孩’
else ’ 其他’ end
–Case 搜索函数
case when sex = ‘1’ then ‘男’
when sex = ‘2’ then ‘女’
else ‘其他’ end