This question asked in CBSE SQP-2021

In SQL, what is the use of IS NULL operator?

 

Answer:

The IS NULL operator is used to check if a column has null/empty value.

Syntax: SELECT column_names

      FROM table_name

      WHERE column_name IS NULL ;

 

Example:

Question 8 Very short- image 1.jpg

Question 8 Very short- image 2..jpg


Transcript

This question asked in CBSE SQP-2021 In SQL, what is the use of IS NULL operator? Answer: The IS NULL operator is used to check if a column has null/empty value. Syntax: SELECT column_names FROM table_name WHERE column_name IS NULL; Example:

Go Ad-free
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.