select case when flag = 1 then '复天' when flag =2 then '秋天' when flag = 3 then '冬天' when flag = 4 then '春天' end as '四季' 或decode(flag,1,'复天',2,秋天,3,'冬天',4,'春天')
select decode(flag,1,'夏天',2,'秋天',3,'冬天',4,'春天') from table
decode, case when都可以搞 SQL> select * from test;FLAG ---------- 1 2 3 2SQL> select decode(flag, '1', '春天', '2', '夏天','其它') from test;DECO ---- 春天 夏天 其它 夏天
select decode(id,1,'复天',2,'秋天',3,'冬天',4,'春天') from aselect case when id = 1 then '复天' when id = 2 then '秋天' when id = 3 then '冬天' when id = 4 then '春天' end 四季 from a
select case id when 1 then '复天' when 2 then '秋天' when 3 then '冬天' when 4 then '春天' end 四季 from a 三种写法
when flag =2 then '秋天'
when flag = 3 then '冬天'
when flag = 4 then '春天'
end as '四季'
或decode(flag,1,'复天',2,秋天,3,'冬天',4,'春天')
SQL> select * from test;FLAG
----------
1
2
3
2SQL> select decode(flag, '1', '春天', '2', '夏天','其它') from test;DECO
----
春天
夏天
其它
夏天
select decode(id,1,'复天',2,'秋天',3,'冬天',4,'春天')
from aselect case when id = 1 then '复天'
when id = 2 then '秋天'
when id = 3 then '冬天'
when id = 4 then '春天'
end 四季
from a
select case id
when 1 then '复天'
when 2 then '秋天'
when 3 then '冬天'
when 4 then '春天'
end 四季
from a
三种写法