EXISTS and NOT EXISTS
• EXISTS and NOT EXISTS are specialized forms of correlated subqueries.
– An EXISTS condition is true if any row in the subquery meets the specified conditions.
– A NOT EXISTS condition is true only if all rows in the subquery do not meet the specified condition.
• The use of a double NOT EXISTS can be used to find rows that have some specified condition to every row of a table.