sql有张表有以下字段

[夏日正午阳光]

有张表有以下字段
id mo
1 y
2 n
请用select语句将y显示为yes，n显示为no
id mo
1 yes
2 no

[xman_78tom]

select id,
(case mo when 'y' then 'yes' when 'n' then 'no' else mo end) mo
from tb;

[SQL2088]

select id,mo=case when mo='y' then 'yes' else 'no' end 
from tb

[「已注销」]

select id ,case mo when 'y' then 'yes' else 'no' end mo
from tb

[dawugui]

[Quote=引用楼主 xie99lin 的回复:]
有张表有以下字段
id mo
1 y
2 n
请用select语句将y显示为yes，n显示为no
id mo
1 yes
2 no
[/Quote]
select id , no = 'yes' from tb where no = 'y'
union all
select id , no = 'no' from tb where no = 'n'

[天下如山]

使用CASE WHEN。

[如影随从]

select id,
(case mo when 'y' then 'yes' when 'n' then 'no' else mo end) mo
from tb;