插入子查询结果(续) 第二步:插入数据 INSERT INTO Deptage( sdept, Avgage) SELECT Sdept, AVG( Sage) FROM Student GROUP BY Sdept An Introduction to Database SystemAn Introduction to Database System 插入子查询结果(续) 第二步:插入数据 INSERT INTO Deptage(Sdept,Avgage) SELECT Sdept,AVG(Sage) FROM Student GROUP BY Sdept;