select null values
In some cases we are in need of selecting only null values from a table. Hence use IS condition as,