Many beginners on SQL often confuse these 3 terms in SQL, and it is truth they look very similar but their functionality is completely different and it is used for different things. Let’s start with the definition of NULL.
NULL is the absence of any value, but it is not 0 (zero) and it’s also not an empty string
. 