sql query

Question

Comments

Comment on this :

---

Yes I also think it should be zero

---

answer is 4

Refere this link for good explanation

https://stackoverflow.com/questions/28946163/all-operator-vs-any-on-an-empty-query

Answer 1

The ALL operator returns TRUE if all of the subquery values meet the condition.

0 columns may be returned