不好意思!谢谢一缺三大哥! 但是我还想继续问一个小问题我是这样做的!select id as 编号,sex=case when sex='01' then '男性' when sex='02' then '女性' else '未知' end as 性别, name as 姓名 from student但是提示我as 性别那里有错!请在多指教指教!如果不加as性别!您给小妹写的语法完全正确!
select id as 编号,case sex when '01' then '男性' when '02' then '女性' else '未知' end as 性别, name as 姓名 from student
改一下:select id '编号','性别'=case sex when '01' then '男性' when '02' then '女性' else '未知' end, name '姓名' from student
select id as 编号,sex=(case when sex='01' then '男性' when sex='02' then '女性' else '未知' end ) as 性别, name as 姓名 from student
select id as 编号,case when sex='01' then '男性' when sex='02' then '女性' else '未知' end as 性别, name as 姓名 from student
select id as 编号,case when sex='01' then '男性' when sex='02' then '女性' else '未知' end as 性别, name as 姓名 from student
select id as 编号,sex=case when sex='01' then '男性' when sex='02' then '女性' else '未知' end 性别, name as 姓名 from student
select id as 编号,sex=case when sex='01' then '男性' when sex='02' then '女性' else '未知' end 性别, name as 姓名 from student
select id as 编号,(case when sex='01' then '男性' when sex='02' then '女性' else '未知' end) as 性别, name as 姓名 from student 肯定正确!测试过!
select id as 编号,性别=case when sex='01' then '男性' when sex='02' then '女性' else '未知' end, name as 姓名 from student
但是我还想继续问一个小问题我是这样做的!select id as 编号,sex=case when sex='01' then '男性'
when sex='02' then '女性'
else '未知'
end as 性别,
name as 姓名
from student但是提示我as 性别那里有错!请在多指教指教!如果不加as性别!您给小妹写的语法完全正确!
when '02' then '女性'
else '未知'
end as 性别,
name as 姓名
from student
when '02' then '女性'
else '未知'
end,
name '姓名'
from student
when sex='02' then '女性'
else '未知'
end ) as 性别,
name as 姓名
from student
when sex='02' then '女性'
else '未知'
end as 性别,
name as 姓名
from student
when sex='02' then '女性'
else '未知'
end as 性别,
name as 姓名
from student
when sex='02' then '女性'
else '未知'
end 性别,
name as 姓名
from student
when sex='02' then '女性'
else '未知'
end 性别,
name as 姓名
from student
when sex='02' then '女性'
else '未知'
end) as 性别,
name as 姓名
from student
肯定正确!测试过!
when sex='02' then '女性'
else '未知'
end,
name as 姓名
from student