A.SELECT Sno, COUNT(*) FROM SC GROUP BY Sno B.SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*)> 3 C.SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*)> 3 D.SELECT Sno FROM SC GROUP BY Sno
A.SUM(列名) B.MAX(列名) C.AVG(列名) D.COUNT(*)
A.左外連接 B.右外連接 C.內(nèi)連接 D.自連接