when to give null and not null in sql query code example

Example 1: sql not null

SELECT column_name FROM table_name 
WHERE column_name IS NOT NULL;

Example 2: sql from null to not null

ALTER TABLE ime_tabele
ALTER stolpec SET NOT NULL;