!--NEWSZW_HZH_BEGIN--
具体不空话了,请看下文详解。
use db_CSharp go select *, 备注=case when Grade>=90 then "成就优良" when Grade<90 and Grade>=80 then "成就良好" when Grade<80 and Grade>=70 then "成就合格" else "不合格" end from tb_Grade use db_CSha
!--NEWSZW_HZH_BEGIN--
具体不空话了,请看下文详解。
use db_CSharp go select *, 备注=case when Grade>=90 then "成就优良" when Grade<90 and Grade>=80 then "成就良好" when Grade<80 and Grade>=70 then "成就合格" else "不合格" end from tb_Grade use db_CSha