INSERT INTO A SELECT SNAME,C.AVGBBB FROM (SELECT s#,AVG(grade) AVGBBB FROM 成绩表 GROUP BY s#) C,S
WHERE C.AVGBBB = (SELECT MAX(AVGBBB) FROM (SELECT s#,AVG(grade) AVGBBB FROM 成绩表 GROUP BY s#)) AND S.S#=C.S#;
没测试,你试试看
WHERE C.AVGBBB = (SELECT MAX(AVGBBB) FROM (SELECT s#,AVG(grade) AVGBBB FROM 成绩表 GROUP BY s#)) AND S.S#=C.S#;
没测试,你试试看
GuoYangHai(Start) 写的不对!
你的oracle版本是8i以下的?
(SELECT S.SNAME,AVG(SC.GRADE)
FROM S,C,SC
WHERE S.S# = SC.S#
GROUP BY S.SNAME
HAVING AVG(SC.GRADE) >= ALL( SELECT MAX(AVG(SC.GRADE))
FROM SC
GROUP BY SC.S#))
INSERT INTO A
SELECT S.SNAME,AVG(SC.GRADE)
FROM SC,S
WHERE SC.S#=S.S#
GROUP BY S.SNAME
HAVING AVG(SC.GRADE)=(SELECT MAX(AVG(GRADE))
FROM SC
GROUP BY SC.S#)