A Field with No value can be represented as a NULL Value. NULL means an absence of any value. Therefore, A NULL value in a field is different than having a Zero value or a space.
IS NULL SYNTAX
IS NOT NULL SYNTAX
SELECT : KEYWORD used to Fetch data from a database
Table_Name : The Table name from where you want to fetch the data
IS NULL/IS NOT NULL : KEYWORD used to determine type of values
NULL & NOT NULL OPERATORS
Want More SQL Deep Dives