How to check null value in SQL?

Question

Can anyone explain how to check the null values in SQL?

Answer 1

We can use IS NULL and IS NOT NULL operators to check null values in SQL. Here is the syntax to use IS NULL and IS NOT NULL operators:

SELECT column_names
FROM table_name
WHERE column_name IS NULL| IS NOT NULL;

Here is the statement to return all the customers with a NULL value in the Address column:

SELECT Customer_Name, Address

FROM Customers

WHERE Address IS NULL;

You can go through this SQL Tutorial blog by Intellipaat for a detailed explanation of IS NULL and IS NOT NULL operators.