A.Sum()B.Max()C.Avg()D.Count()
A.SELECT Sno,COUNT(*)FROM SC GROUP BY SnoB.SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*)>3C.SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*)>3D.SELECT Sno FROM SC GROUP BY Sno
A.將查詢結(jié)果插入到一個新表中B.將查詢結(jié)果插入到一個已建好的表中C.合并查詢的結(jié)果D.向已存在的表中添加數(shù)據(jù)