表sc
SELECT sc1.sno
FROM sc sc1,sc sc2
WHERE sc1.sno = sc2.sno AND
sc1.cno = 'c1' AND
sc2.cno = 'c2' AND
sc1.score > sc2.score;
表sc
SELECT sc1.sno
FROM sc sc1,sc sc2
WHERE sc1.sno = sc2.sno AND
sc1.cno = 'c1' AND
sc2.cno = 'c2' AND
sc1.score > sc2.score;