USE MySchool--查询所有科目的参考信息（某些科目可能还没有被考试过）SELECT J.SubjectName AS 科目名称,R.StudentNo AS 学号,R.StudentResult AS 分数FROM Subject AS JLEFT OUTER JOIN Result AS RON J.SubjectId=R.SubjectIdSELECT J.SubjectName AS 科目名称,R.StudentNo AS 学号,R.StudentResult AS 分数FROM Result AS RRIGHT OUTER JOIN Subject AS JON J.SubjectId=R.SubjectId--查询没有被考过的科目信息。SELECT J.SubjectName AS 科目名称FROM Result AS RRIGHT OUTER JOIN Subject AS JON J.SubjectId=R.SubjectIdWHERE R.StudentResult IS NULL AND R.StudentNo IS NULL--所有年级对应的学生信息（需要考虑某些年级可能还没有学生就读）SELECT G.GradeName AS 年级, S.StudentNo AS 学号,S.StudentName AS 姓名FROM Grade AS GLEFT OUTER JOIN Student AS SON G.GradeId=S.GradeIdSELECT G.GradeName AS 年级, S.StudentNo AS 学号,S.StudentName AS 姓名FROM Student AS SRIGHT OUTER JOIN Grade AS GON G.GradeId=S.Grade
--查询学生学号、姓名、考试科目名称及成绩。SELECT S.StudentNo AS 学号,S.StudentName AS 姓名,J.SubjectName AS 科目名称,R.StudentResult AS 成绩FROM Result AS RINNER JOIN Student AS S ON(R.StudentNo=S.StudentNo)INNER JOIN Subject AS J ON(R.SubjectId=J.SubjectId)SELECT S.StudentNo AS 学号,S.StudentName AS 姓名,J.SubjectName AS 科目名称,R.StudentResult AS 成绩FROM Result AS R,Student AS S,Subject AS JWHERE(R.StudentNo=S.StudentNo) AND (R.SubjectId=J.SubjectId)--查询参加“走进Java编程世界”考试的学生姓名、成绩、考试日期。SELECT S.StudentName AS 姓名,R.StudentResult AS 成绩,R.ExamDate AS 考试日期FROM Result AS RINNER JOIN Student AS S ON (R.StudentNo=S.StudentNo)INNER JOIN Subject AS J ON(R.SubjectId=J.SubjectId)WHERE J.SubjectName='走进Java编程世界' SELECT S.StudentName AS 姓名,R.StudentResult AS 成绩,R.ExamDate AS 考试日期FROM Result AS R, Student AS S ,Subject AS JWHERE(R.StudentNo=S.StudentNo) AND (R.SubjectId=J.SubjectId)AND J.SubjectName='走进Java编
0 0
