首页 > 试题广场 >

如果要选择Student_A和Student_B表中公共部分

[单选题]
 如果要选择Student_A和Student_B表中公共部分,并按照class_id降序输出,请问该如何补全以下这段SQL语句()(注明:只需要输出Student_A或Student_B的student_id和student_name字段)
SELECT student_id, student_name FROM Student_A __________________;
  • INTERSECT SELECT student_id, student_name FROM Student_B ORDER BY class_id DESC;
  • EXCEPT SELECT student_id, student_name FROM Student_B ORDER BY class_id DESC;
  • INTERSECT SELECT student_id, student_name FROM Student_B ORDER BY class_id;
  • NOT INTERSECT SELECT student_id, student_name FROM Student_B ORDER BY class_id DESC;

这道题你会答吗?花几分钟告诉大家答案吧!