Home »
MCQs »
SQL MCQs »
SQL EXCEPT Clause MCQs
What is TRUE about NOT IN clause?
7. What is TRUE about NOT IN clause?
- The result is purged of duplicates
- Duplicate records are not removed
- Performs column-by-column comparisons
- None of the above
Answer: B) Duplicate records are not removed
Explanation:
In the case of the NOT IN clause, Duplicate records are not removed.