Question

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 mentioned

I had been asked this question in examination.

Enquiry is from Joins topic in chapter Laying the Foundation of SQL Server

Answer 1

Right option is (a) Involves the use of an inner and outer query

To explain I would say: Subquery—also referred to as an inner query or inner select—is a SELECT statement embedded within a data manipulation language (DML) statement or nested within another subquery.