0 votes
in Oracle by

What is a sub query and what are the different types of subqueries?

1 Answer

0 votes
by

Sub Query is also called as Nested Query or Inner Query which is used to get data from multiple tables. A sub query is added in the where clause of the main query.

There are two different types of subqueries:

  • Correlated sub query

A Correlated sub query cannot be as independent query but can reference column in a table listed in the from list of the outer query.

  • Non-Correlated subquery

This can be evaluated as if it were an independent query. Results of the sub query are submitted to the main query or parent query.

Related questions

0 votes
asked May 11, 2020 in Oracle by JackTerrance
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...