Correlated Subquery « Subquery « Oracle PL / SQL

1.

A correlated subquery references one or more columns in the outer query

2.

Using EXISTS with a Correlated Subquery

3.

Using NOT EXISTS with a Correlated Subquery

4.

Inner query Demo

5.

Get Categories and Products (with Correlated Subqueries)

6.

A correlated subquery: the subquery references a column from a table referred to in the parent statement.

7.

How Many Products By Department with correlated subqueries 2

8.

To delete the records of emps whose salary is below the average salary in the department (correlated subquery):

9.

To update the salary of all emps to the maximum salary in the corresponding department (correlated subquery):