Hi,

Nice query and explanation, but still need clarification when to use <> ALL and NOT IN. Since in this result are same. if possible please illustrate.