select sname,re,
level=
case
when credits >60 then '及格'
else'优秀'
end
from test;执行失败:ORA-00923: 未找到预期 FROM 关键字怎么回事
select
level=
case
when credits >60 then '及格'
else'优秀'
end
from test;执行失败:ORA-00923: 未找到预期 FROM 关键字怎么回事
select
re,
case
when credits > 60 then
'及格'
else
'优秀'
end "level"
from test;
case
when credits >60 then '及格'
else'优秀'
end as level
from test;--此种方法和楼上的方法两库都能用