Which two statements are true about WHERE and HAVING clauses? (Choose two)

The correct answer is B. A WHERE clause can be used to restrict rows only. D. A HAVING clause can be used to restrict groups only. B: WHERE clause cannot be use to restrict groups WHERE clause cannot be use when there is group functions. D: A HAVING clause can only e used to restrict GROUPS. Note: HAVING clause to specify which groups are to be displayed and thus further restrict the groups on the basis of…

Restricting and Sorting Data

Question

Options

AA WHERE clause can be used to restrict both rows and groups.
BA WHERE clause can be used to restrict rows only.
CA HAVING clause can be used to restrict both rows and groups.
DA HAVING clause can be used to restrict groups only.
EA WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
FA HAVING clause CANNOT be used in subqueries.

How the community answered

(16 responses)

A
6% (1)
B
69% (11)
C
6% (1)
F
19% (3)

Explanation

B: WHERE clause cannot be use to restrict groups WHERE clause cannot be use when there is group functions. D: A HAVING clause can only e used to restrict GROUPS. Note: HAVING clause to specify which groups are to be displayed and thus further restrict the groups on the basis of aggregate information. The Oracle server performs the following steps when you use the Having clause 1. rows are grouped 2. the group function is applied to the group 3. the group that match the criteria in the Having clause are displayed.

Topics

#WHERE clause#HAVING clause#GROUP BY#row vs group filtering

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice