Subquery is query that appears within another SQL data manipulation statement - SQL Operations

Q.  A subquery is a query (usually enclosed by parentheses) that appears within another SQL data manipulation statement.
- Published on 09 Jul 15

a. True
b. False

ANSWER: True
 
On evaluation a value or a set of values to the statement is provided by the subquery. The WHERE clause is used by the subqueries. An evaluation which is done once for each table is carried out by the subquery and a correlated subquery evaluates only once for for each of the rows.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)