Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following statements is true concerning subqueries?

  • A.Involves the use of an inner and outer query.
  • B.Cannot return the same result as a query that is not a subquery.
  • C.Does not start with the word SELECT.
  • D.All of the above.

Answer: A

Correct answer: Involves the use of an inner and outer query.

A subquery is a SELECT nested inside another, the inner supplying a value or a set to the outer. Many subqueries can be rewritten as joins and return identical results, and the choice between them is usually a matter of readability rather than of what is possible.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.