題目是用子查詢查詢成績不及格的設計MySchool數據庫課程的學生學號,姓名select StudentNo,StudentName,GradeIdfrom Studentwhere GradeId=( select GradeID from Subject where SubjectName='設計MySchool數據庫' and SubjectID in( select SubjectID from Result where StudentResult<60? ))select StudentNo,StudentName,GradeIDfrom Studentwhere StudentNo in( select StudentNo from Result where ?StudentResult<60 and SubjectID =( select SubjectID from Subject where SubjectName='設計MySchool數據庫' ))為什么條件倒換一下答案就錯了,下面的一段代碼是對的
各位大佬!
qq_風_21
2018-05-04 16:57:33