Which clause should you use to exclude group results?

The correct answer is B. HAVING. HAVING clause is used to weed out unwanted data once the data is grouped using the GROUP Incorrect Answers A: WHERE clause cannot be used for this purpose. C: There is no RESTRICT command in Oracle. D: GROUP BY cannot be used itself to exclude group results. E: ORDER BY clause…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

Options

AWHERE
BHAVING
CRESTRICT
DGROUP BY
EORDER BY

How the community answered

(43 responses)

A
9% (4)
B
81% (35)
C
5% (2)
D
2% (1)
E
2% (1)

Explanation

HAVING clause is used to weed out unwanted data once the data is grouped using the GROUP Incorrect Answers A: WHERE clause cannot be used for this purpose. C: There is no RESTRICT command in Oracle. D: GROUP BY cannot be used itself to exclude group results. E: ORDER BY clause may be used only to sort final results, not to exclude group results.

Topics

#HAVING clause#group filtering#GROUP BY#aggregate functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice