本文共 741 字，大约阅读时间需要 2 分钟。

题目：（困难）

标签：SQL

解法一：

SELECT student_id,       student_nameFROM StudentWHERE student_id NOT IN (SELECT DISTINCT student_id                         FROM Exam AS E1                                  LEFT JOIN                              (SELECT exam_id,                                      MIN(score) AS min_score,                                      MAX(score) AS max_score                               FROM Exam                               GROUP BY exam_id) AS E2 ON E2.exam_id = E1.exam_id                         WHERE E1.score = E2.min_score                            OR E1.score = E2.max_score)  AND student_id IN (SELECT DISTINCT student_id FROM Exam);

转载地址：https://dataartist.blog.csdn.net/article/details/110423675 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！