如果要选择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;
这道题你会答吗?花几分钟告诉大家答案吧!