10.5. Summary

In this chapter, we discussed the correlated subquery, noncorrelated subquery, EXISTS, and NOT EXISTS. We described situations where the correlation of a subquery is necessary and can be written with the EXISTS predicate, and other times when EXISTS can be used, even with no correlation. We also introduced loops and discussed how the "for all" and "for each" are used in SQL.