Question 8 - Past Year - 1 Mark Questions - Chapter 9 - Structured Query Language

Last updated at April 16, 2024 by

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

Go Ad-free

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:

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 and Computer Science at Teachoo