10. 資料表 Staff 之欄位屬性定義:Id INTEGER、Name CHAR(20)、Dept INTEGER、Job CHAR(20)、Years INTEG ER、 Salary DECIMAL(10, 2)、Comm DECIMAL(10,2) ;欲表列「至少有一個員工的酬金(Comm)在 5,000 元以 上」之部門編號及員工總數,最能符合要求之 SQL 語法為何?
(A)SELECT Dept, COUNT(*) FROM Staff GRO UP BY Dept HAVING Comm>5000
(B)SELECT Dept, COUNT(*) FROM Staff WHERE Comm>5000 GROUP BY Dep t, Comm
(C)SELECT Dept, COUNT(*) FROM Staff GROUP BY Dept HAVING MAX(Comm)>5000
(D)SELECT Dept, Comm, COUNT(id) FROM Staff WHERE Comm>5000 GROUP BY Dept, Comm。

答案:登入後查看
統計: A(2), B(1), C(10), D(3), E(0) #1126880