問題詳情

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

參考答案

答案:C
難度:適中0.5
統計:A(0),B(0),C(0),D(0),E(0)

內容推薦