There are are many entries having NUll as ShippedDate, one of them can be seen in the photo, but when i search for those entries where ShippedDate is NULL is get a empty set.
How do i select all having NULL as ShippedDate
Advertisement
Answer
You use wrong operator, equal not work with null
... WHERE ShippedDate is NULL