Multiple Choice
Which clause is used when the group results of a subquery need to be restricted,based on some condition?
A) GROUP BY
B) HAVING
C) WHERE
D) ORDER BY
Correct Answer:

Verified
Correct Answer:
Verified
Q105: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q106: Valid multiple-row operators include ANY,ALL,and _.
Q107: Contents of the BOOKS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q108: The results of the outer query are
Q109: The<u> =ANY</u> operator yields the same results
Q111: A(n)<u>correlated</u> subquery references one or more columns
Q112: The >ALL operator indicates that a value
Q113: IN is not a valid operator for
Q114: A subquery is a complete query nested
Q115: If a multiple-column subquery is contained in