sql select null values code example

Example 1: sql select column with value NULL

SELECT * FROM table_name WHERE column_name IS NULL

Example 2: get null value in sql

SELECT * FROM my_table WHERE col1 IS NULL;

Example 3: how to check if a column is null in sql

SELECT column_name FROM table_name 
WHERE column_name IS NULL;