Correlated Subquery « Query Select « Oracle PL/SQL Tutorial

2.37.Correlated Subquery
	2.37.1.	Writing Correlated Subqueries
	2.37.2.	Using EXISTS and NOT EXISTS with a Correlated Subquery
	2.37.3.	A correlated subquery: the subquery references a column from a table referred to in the parent statement.
	2.37.4.	The subquery returning the literal value 1
	2.37.5.	Using NOT EXISTS with a Correlated Subquery
	2.37.6.	list all employees who is younger than Joe
	2.37.7.	List all employees who attended XML course and Java course
	2.37.8.	Extract a Subset of the Results
	2.37.9.	How Many Products By Department with correlated subqueries 1

	2.37.10.	How Many Products By Department with correlated subqueries 2
	2.37.11.	Correlated subquery using the EXISTS operator