Ace Test Series 2019: DBMS - SQL Output

Question

 

Comments

But according to me its $\mathbf 0$ only.

Let's see if someone else come up with different logic.

---

I have created a similar table and executed the query, According to this answer should be A) 2 rows.

---

I don't know but theoretically it should be 0.

Answer 1

A 2
When b,c compare with  a then it return two tuple

Comments

@Ram Swaroop    how u compare with NULL value????

 

---

@Hradesh patel
No we can't compare with null value
But comparison can only be done with a that return 2 row