數(shù)據(jù)庫1數(shù)據(jù)查詢-文庫吧資料
2025-07-04 14:15本頁面
【正文】 rom student where student_id in( select student_id from sc where course_id=( select course_id from course where course_name=39。)11. 查詢選修了課程名為“數(shù)據(jù)庫基礎(chǔ)”的學生學號和姓名（分別用連接，in和exists實現(xiàn)）連接：select , from sc,student,course where =39。)exists：select student_id,course_id,grade from sc where exists( select * from course where course_id= and course_name=39。 and =In：select student_id,course_id,grade from sc where course_id in( select course_id from course where course_name=39。 and grade80)10. 查詢所有上計算機基礎(chǔ)課程的學生的學號、選修課程號以及分數(shù)（分別用連接，in和exists實現(xiàn)）連接：select sc.* from sc,course where =39。 and grade80) exists：select * from student where exists( select student_id from sc where = and course_id=39。 and 80In：select * from student where student_id in( select student_id from sc where course_id=39。（分別用連接，in和exists實現(xiàn)）連接：select student.* from sc,
研究報告相關(guān)推薦
鄂ICP備17016276號-1