select a.id,a.colA ,
case when a.colA='11' then '这是11'
when a.colA='22' then '这是22'
else '例外'
end anyNameYouLike
from TA a
update students
set grade = (
select grade from
(
select id,
case when current_credits > 90 then 'a'
when current_credits > 80 then 'b'
when current_credits > 70 then 'c'
else 'd' end grade
from students
) a
where a.id = students.id
)
case when a.colA='11' then '这是11'
when a.colA='22' then '这是22'
else '例外'
end anyNameYouLike
from TA a
update students
set grade = (
select grade from
(
select id,
case when current_credits > 90 then 'a'
when current_credits > 80 then 'b'
when current_credits > 70 then 'c'
else 'd' end grade
from students
) a
where a.id = students.id
)
扫一扫
174
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
