Which two statements are true about the WHERE and HAVING clauses in aSELECTStatement? (Choose two.)
选项:
A: Aggregating functions and columns used in HAVING clauses must be specifiedIn the SELECT list of a query
B: WHERE and HAVING clauses can be used in the same statement only if appliedTo different table columns
C: The HAVING clause can be used with aggregating functions in subqueries
D: The WHERE clause can be used to exclude rows before dividing them intoGroups
E: The WHERE clause can be used to exclude rows after dividing them into groups
发布时间:2024-06-11 23:37:32