SELECT * FROM grade;
#查询S2学员考试成绩信息
SELECT r.studentNO AS 学生学号, r.subjectNO AS 科目编号,r.studentResult AS 考试成绩, r.examtime AS 考试时间 FROM result r
INNER JOIN student s ON r.studentNO = s.studentNO
#如果子查询语句有结果则返回true
WHERE EXISTS(
#查询是否存在 resultS2 的学生
SELECT * FROM student WHERE gradeId = (
#查询年级为 S2 的编号
SELECT gradeId FROM grade
WHERE gradeName = 'S2'
)
)AND s.gradeId = (
#年级 S2 的编号
SELECT gradeId FROM grade
WHERE gradeName = 'S2'
);