tableAA
name address sex memo
AAA zzzzz 0 123131
BBB xxxxx 0 123131
CCC ttttt 1 123131
DDD uuuuu 1 123131 其中sex列只会出现 0 或1 不可能为其它数值 或为空 我想得到 0 ‘男’ 1‘女’在显示出来的时候为
name address sex memo
AAA zzzzz 男 123131
BBB xxxxx 男 123131
CCC ttttt 女 123131
DDD uuuuu 女 123131
name address sex memo
AAA zzzzz 0 123131
BBB xxxxx 0 123131
CCC ttttt 1 123131
DDD uuuuu 1 123131 其中sex列只会出现 0 或1 不可能为其它数值 或为空 我想得到 0 ‘男’ 1‘女’在显示出来的时候为
name address sex memo
AAA zzzzz 男 123131
BBB xxxxx 男 123131
CCC ttttt 女 123131
DDD uuuuu 女 123131
select name , address, (case sex when 0 then "女" else "男" end) sex , memo from tableAA
select name,address,sex=case sex when '0' then '男' when '1' then '女' end ,memo from tablename
[name]
,address
,case sex
when '0' then '男'
when '1' then '女'
end
,memo
from tableAA
select name,address,(case sex when 0 then '男' else '女' end) sex,memo
from tableAA
select name,address,sex=case sex when '0' then '男' when '1' then '女' end ,memo from tablename
select name,
address,
sex = case when sex = 0 then '男' else '女' end ,
memo
from tb--2
select name,
address,
sex = '男',
memo
from tb where sex = 0
union all
select name,
address,
sex = '女',
memo
from tb where sex = 1
case sex
when '0' then '男'
when '1' then '女'
end,
memo
from tableAA