Viewing 2 posts - 1 through 2 (of 2 total)
Thanks a lot for clearing all my doubts.
😀
February 4, 2010 at 3:20 am
#1113583
In the case of NOT in,
SELECT n FROM Nums WHERE n NOT IN (1, 2, null)
equates to
WHERE n != 1 AND n !=2 and n!=null
The 3rd returns null...
February 4, 2010 at 2:38 am
#1113568