How to Work with IS NULL Clause in SQL
In this article I am going to explain how to work with IS NULL Clause in SQL.
Introduction
In this article I am going to explain how to work with IS NULL Clause in SQL. IS NULL clause is used to fetch row that contain null value. Null value is not same as zero, empty string (' ') or a blank space. Null value means it is unknown value.
IS NULL Clause is used with WHERE clause. We can use NOT keyword with IN NULL clause.
Example
select * from mcninvoices
where paymenttotal IS NULL
|
Output
Example
select * from mcninvoices
where paymenttotal IS NOT NULL
|
Output