Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement?

Which three statements are true regarding the WHERE and HAVING clauses in a SQL
statement? (Choose three.)

Which three statements are true regarding the WHERE and HAVING clauses in a SQL
statement? (Choose three.)

A.
The HAVING clause conditions can use aliases for the columns.

B.
The HAVING clause is used to exclude one or more aggregated results after grouping
data.

C.
WHERE and HAVING clauses cannot be used together in a SQL statement.

D.
The HAVING clause conditions can have aggregate functions.

E.
The WHERE clause is used to exclude rows before the grouping of data.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Ab Hin

Ab Hin

Answer: B, D & E