34,837
社区成员
发帖
与我相关
我的任务
分享请教一条SQL语句
Name Sex
David 1
Mark 1
Jone 0
Cristal 0
输出为
David(male)
Mark(male)
Jone(female)
Cristal(female)
SQL 怎么写？谢谢！
David 1
Mark 1
Jone 0
Cristal 0
输出为
David(male)
Mark(male)
Jone(female)
Cristal(female)
SQL 怎么写？谢谢！
...全文
请发表友善的回复…
发表回复
wzy_love_sly 2008-03-11
- 打赏
- 举报
select case when sex=1 then name+'(male)' else name+'(female)' end from tb
-狙击手- 2008-03-11
- 打赏
- 举报
select name+'('+case when sex = 1 then 'male' else 'female' end+')'
from T-狙击手- 2008-03-11
- 打赏
- 举报
select name+case when sex = 1 then 'male' else 'female' end
from T
