1
select a.*,b.score as 01_score,c.score as 02_score from student a,sc b,sc c
where a.SId=b.SId
and b.SId=c.SId
and b.CId='01'
and c.CId='02'
and b.score>c.score
image.png
SELECT t.*,student.Sage,student.Sname,student.Ssex
FROM
(
SELECT sc1.SId,sc1.score 01score,sc2.score 02score
FROM sc sc1,sc sc2
WHERE sc1.SId=sc2.SId AND sc1.score>sc2.score AND sc1.CId='01'AND sc2.CId='02'
) AS t
LEFT JOIN student
ON t.SId=student.SId
image.png
2
未完待续。。。
网友评论