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

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

Question

Quizplus · Accepted Answer

In a double nested set of NOT EXISTS SELECT statements, if a row does not match any row, it returns true for the outer NOT EXISTS, causing it to not match any row as well. Therefore, every row matches.

When Using a Double Nested Set of NOT EXISTS SELECT