Thursday, March 12, 2015

What is NULL.

NULL is a value that is unavailable, unassigned, unknown or inapplicable. If a column in a row has no value, then the column we can said null value.

Arithmetic Operation With NULL : All types of arithmetic operation with null value result will be null.

Count function with NULL : Count (EXP) function return the result only for not null value. COUNT(*) return the result with null and not null values.

No comments:

Post a Comment