34,576
社区成员
发帖
与我相关
我的任务
分享
ALTER TABLE dbo.Student ADD [学分] AS
CASE WHEN age<10 THEN credit+8
WHEN age>=10 THEN credit+5
END
SELECT s.NAME,s.class,s.age,s.sex,s2.[SUBJECT],s2.score,
--CASE s.credit WHEN s.credit<10 THEN s.credit+8
--WHEN s.credit>=10 THEN s.credit+5
CASE
WHEN s.age<10
THEN s.credit+8
WHEN s.age>=10
THEN s.credit+5
END AS 学分
FROM dbo.Student AS s
left JOIN dbo.Score AS s2
ON s.NAME=s2.NAME