Challenge: Understanding Nulls
Try a hands-on exercise to test your knowledge and understanding of NULLs.
We'll cover the following
Problem statement
In this challenge, you will complete two tasks to test your knowledge and understanding of null in SQL.
Task 1
Programming languages come with a special value for null values. SQL deals with such values differently than other languages because it provides a three-valued logic for nulls. Let’s check the behavior of null with the values true
, false
, and null
.
Write a query to list the output using the SQL operator is null
for the values true
, false
, and null
.
Get hands-on with 1400+ tech skills courses.