Question

In a subquery, the all operator compares a value to every value returned by the inner query. True or false?

Answer 1

Answer:

TRUE

Explanation:

In a subquery, the all operator compares a value to every value returned by the inner query. - TRUE

The ALL operator compares every value returned by the subquery. It is synonyms of ANY operator.

the result of sub query is used by main query. the subquery which is inner query executes once before main query (which is outer query).

There are 2 types of sub queries :-

1) Single Row subquery -This returns single record

2) Multiple Row subquery -This returns multiple records