NULL VALUE

A Field with No value can be represented as a NULL Value. NULL means an absence of any value. Therefore, A NULL value in a field is different than having a Zero value or a space.

IS NULL SYNTAX

IS NOT NULL SYNTAX

 
 
 

Where,

  • SELECT                                                    : KEYWORD used to Fetch data from a database

 

  • Table_Name                        : The Table name from where you want to fetch the data

 

  • IS NULL/IS NOT NULL             :  KEYWORD used to determine type of values

 

NULL & NOT NULL OPERATORS

 

PRACTICE YOURSELF 

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin