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.
  • 1569

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

Clipboard04.jpg

Example

select * from mcninvoices
where paymenttotal IS NOT NULL

Output

 Clipboard06.jpg


© 2018 DotNetHeaven. All rights reserved.