SELECT distinct 学号,
(SELECT 考试成绩
FROM msm_cjb
WHERE 学期 = '4' AND 课程代号 = '55' AND 学号 = aa.学号) AS 语文,
(SELECT 考试成绩
FROM msm_cjb
WHERE 学期 = '4' AND 课程代号 = '56' AND 学号 = aa.学号) AS 数学
FROM Msm_Cjb aa
(SELECT 考试成绩
FROM msm_cjb
WHERE 学期 = '4' AND 课程代号 = '55' AND 学号 = aa.学号) AS 语文,
(SELECT 考试成绩
FROM msm_cjb
WHERE 学期 = '4' AND 课程代号 = '56' AND 学号 = aa.学号) AS 数学
FROM Msm_Cjb aa
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货