SQL query with NOT IN connective.

Question

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

Comments

option d :-  3

---

@shaik Masthan, Does NOT IN connective on empty set returns TRUE? please elaborate

---

as per my knowledge yes.

 

take each row, and evaluate.

what happens NOT IN is replaced by IN operator?

first tuple from A, (12,A,60) taken, condition age IN ( some values )

if age = value1 or age = value2 or age = value3 or ........ then return true.

 

what happens in case of NOT IN

if age ≠ value1 and age ≠ value2 and age ≠ value3 and ........ then return true.

yes my value is not matched by any value (in case of empty table also) ===> return true.

 

for confirmation i run it on W3 Schools.com also.

 

NOT IN (EMPTY TABLE)  ====> always true.

IN (EMPTY TABLE) ====> always false.

---

yes my value is not matched by any value (in case of empty table also) ===> return true.

 That explains it beautifully...Thanks a lot brother :)

---

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