In a doubly nested set of NOT EXISTS SELECT statements,________.
A)if a row does not not match any row,then it matches every row
B)if a row matches any row,then it matches every row
C)if a row does not match any row,then it does not match every row
D)if a row matches any row,then it does not match every row

Question

Quizplus · Accepted Answer

In a doubly nested NOT EXISTS, if a row does not match any row in the subquery, it means the condition is true for every row, hence it matches every row.

In a Doubly Nested Set of NOT EXISTS SELECT Statements,________