SELECT CASE 语句 ****** select id ,'sexNo'= case when sex='先生' then 2 when sex='女士' then 3 else 1 end ,age FROM [ comsiterefer] 转载于:https://www.cnblogs.com/hzpin/p/3925185.html