SUBQUERIES

Subqueries in Oracle

Subqueries are select statements which are part of main select statement.

Subqueries can be used in below clauses of a SELECT statement.

• WHERE
• HAVING
• FROM
• ORDER BY

Subqueries are of two types:

• Single row subqueries
• Multiple row

…