select name,
case when zongxuefen>10 then '优秀'
when zongxuefen<10 and zongxuefen>5 then '良好'
else '不合格'
end
as level
case when zongxuefen>10 then '优秀'
when zongxuefen<10 and zongxuefen>5 then '良好'
else '不合格'
end
as level
from XS
转载请著名出处: 找网网-职业(程序员 UI设计 产品经理...)常用网站导航