When using a doubly nested set of NOT EXISTS SELECT statements,a row that does not match any row matches every row.

Name: When using a doubly nested set of NOT EXISTS SELECT statements,a row that does not match any row matches every row.
Brand: Quizplus
Rating: 4.8 (36 reviews)

Question

Quizplus · Accepted Answer

This is true. When using a doubly nested set of NOT EXISTS SELECT statements, a row that does not match any row in the inner SELECT statement will not satisfy the NOT EXISTS condition and therefore will match every row in the outer SELECT statement.

When Using a Doubly Nested Set of NOT EXISTS SELECT