1.
select xuehao,name1,dengji
=
case
when zongfenshu
<50 then '不及格'
when zongfenshu
>=50 and zongfenshu
<=60 then '合格'
else '优秀'
end from aaa
where zhuanyeming
='计算机'
2.
update aaa
set zongfenshu
=
case
when dengji
='及格' then zongfenshu
+5
when dengji
='优秀' then zongfenshu
+20
else zongfenshu
*2
end
转载于:https://www.cnblogs.com/crystal-guoguo/archive/2013/02/27/2934800.html
