Question

What are single row and multiple row subqueries?

Answer 1

$\huge \red {☆AnsWer}$

✏ Single Row => A single-row subquery is used when the outer query's results are based on a single, unknown value. Although this query type is formally called "single-row," the name implies that the query returns multiple columns-but only one row of results...

✏ Multiple Row => Multiple row subquery returns one or more rows to the outer SQL statement. You may use the IN, ANY, or ALL operator in outer query to handle a subquery that returns multiple rows. Contents: Using IN operator with a Multiple Row Subquery. Using NOT IN operator with a Multiple Row Subquery....

Answer 2

Answer:

**** hope it will help you dear ****