Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries 

Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types syntax and guidelines for using subqueries in Oracle.