首页 > 代码库 > SQL_根据不同条件进行更新

SQL_根据不同条件进行更新

update Students set chineseLevel = casewhen chinese < 60 then Dwhen 60<=chinese and chinese <70  then Cwhen 70<=chinese and chinese <80 then Bwhen chinese >= 80 then Aend

 

SQL_根据不同条件进行更新