select name,
case when zongxuefen>10 then '优秀'
when zongxuefen<10 and zongxuefen>5 then '良好'
else '不合格'
end
as level
from XS
case when zongxuefen>10 then '优秀'
when zongxuefen<10 and zongxuefen>5 then '良好'
else '不合格'
end
as level
from XS
case when 例子
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
