null handling in sql

If a column’s field has NULL value then it means, it is blank. This field has no value. When a column’s value is NULL then it can’t be determined by an eqal to (=) operator. The way of identifying NULL values is, you need to use IS NULL or IS NOT NULL statement. NOT NULL … Read more