問題詳情

5. SQL 的 SELECT 指令將資料列用 GROUP BY 分組後，在哪個子句敘明篩選組的條件？
(A) SELECT
(B)WHERE
(C)GROUP BY
(D) HAVING

參考答案

答案：D
難度：適中0.638889
統計：A(1),B(9),C(3),D(23),E(0)

用户評論

【ted】評論

The SQL HAVING ClauseThe HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.https://www.w3schools.com/sql/sql_having.asp