17,377
社区成员
发帖
与我相关
我的任务
分享case 语句的用法
select MAT_NM_TEMP =
case type when 'popular_comp' THEN 'Popular Computing' end
from KPLAN_L 通不过，请指点
case type when 'popular_comp' THEN 'Popular Computing' end
from KPLAN_L 通不过，请指点
...全文
请发表友善的回复…
发表回复
yflag 2003-10-10
- 打赏
- 举报
case when then 是T-SQL语法撒
oracle里有这东东吗？
这是sql server论坛还是oracle?
oracle用decode啦
oracle里有这东东吗？
这是sql server论坛还是oracle?
oracle用decode啦
podded 2003-10-10
- 打赏
- 举报
Nickle_Final的SQL：未找到预期 FROM 关键字
Nickle_Final 2003-10-10
- 打赏
- 举报
酱紫也可以DI
select case type when 'popular_comp' then 'Popular Computing' end MAT_MM_TEMP
from KPLAN_L
select case type when 'popular_comp' then 'Popular Computing' end MAT_MM_TEMP
from KPLAN_L
pengdali 2003-10-10
- 打赏
- 举报
select decode(type,'popular_comp','Popular Computing') MAT_NM_TEMP from KPLAN_L
pengdali 2003-10-10
- 打赏
- 举报
select MAT_NM_TEMP =
decode(type,'popular_comp','Popular Computing')
from KPLAN_L
decode(substr(t0.cag_no,1,1),1,'ab',2,'cd',3,'ef')
decode(type,'popular_comp','Popular Computing')
from KPLAN_L
decode(substr(t0.cag_no,1,1),1,'ab',2,'cd',3,'ef')
