17,086
社区成员
发帖
与我相关
我的任务
分享
UPDATE STUDENT A SET(SCRC)=(
select CASE A.POINT
WHEN 0.9 THEN
(CASE
WHEN A.LL>=0.65 AND A.LL<0.7 THEN 8
WHEN A.LL>=0.7 THEN 9
END)
WHEN 0.85 THEN
(CASE
WHEN A.LL>=0.85 THEN 2
ELSE 3
END)
END
)
UPDATE STUDENT A SET(SCRC)=(
select CASE
WHEN A.POINT = 0.9 THEN
(CASE
WHEN A.LL>=0.65 AND A.LL<0.7 THEN 8
WHEN A.LL>=0.7 THEN 9
END)
WHEN A.POINT = 0.85 THEN
(CASE
WHEN A.LL>=0.85 THEN 2
ELSE 3
END)
END
--你的
UPDATE STUDENT A SET SCRC=(CASE A.POINT
WHEN 0.9 THEN
CASE
WHEN A.LL>=0.65 AND A.LL<0.7 THEN 8
WHEN A.LL>=0.7 THEN 9
END
WEHN 0.85 THEN
CASE WHEN A.LL>=0.85 THEN 2 ELSE 3 END
END
)
--我写的
update STUDENT set SCRC=(case when POINT=0.9 and LL>=0.65 AND LL<0.7 then 8
when POINT=0.9 and LL>=0.7 then 9
when POINT=0.85 and LL>=0.85 then 2
when POINT=0.85 and LL<0.85 then 3
end)