SELECT # As 课程ID, AS 最高分, AS 最低分
FROM SC L ,SC AS R
WHERE # = # and
= (SELECT MAX()
FROM SC AS IL,Student AS IM
WHERE # = # and #=#
GROUP BY #)
AND
= (SELECT MIN()
FROM SC AS IR
WHERE # = #
GROUP BY #
);
自己写的:select c# ,max(score)as 最高分 ,min(score) as 最低分 from group by c#