SQL query with NOT IN connective.

Question

a) 0    b) 1      c) 2        d) 3

Comments

can you tell me what happen when i replace NOTIN by EXCEPT is it 3???

---

EXCEPT

is a SET operator, you can't apply it here.

 

i hope you want to know

(Set1) except (Set2)

1) if Set2 is empty, then result is Set1

2) if Set1 is empty, then result is empty

---

got it.i forget the basic concept.thnx