Mark for review Which two statements are true about WHERE and HAVING clauses? (Choose two.)

Q. Mark for review Which two statements are true about WHERE and HAVING clauses? (Choose two.)

A. A WHERE clause can be used to restrict both rows and groups.

B. A WHERE clause can be used to restrict rows only.

C. A HAVING clause can be used to restrict both rows and groups.

D. A HAVING clause can be used to restrict groups only.

E. A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.

F. A HAVING clause CANNOT be used in subqueries.


Answer: B,D