1.查询
2.结果
[img]http://dl.iteye.com/upload/attachment/199274/3438236f-7047-3481-912c-f0b7bfaf9318.jpg[/img]
select case when sex = '男' then '1'
when sex = '女' then '2'
else '3'
end 性别编号
from temp
2.结果
[img]http://dl.iteye.com/upload/attachment/199274/3438236f-7047-3481-912c-f0b7bfaf9318.jpg[/img]