SQL Tutorial for Data Analysis 13: IS NULL Operator

In this SQL tutorial we’re going to learn how to use the IS NULL operator. This operator, as you're about to see - allows us to search for fields with no value.

Key concepts to remember -
* NULL indicates an empty, unavailable or unassigned value. NULL value does not equal to zero (0), or space (‘ ‘). Null simply means a field with no value.

Course Examples -

ACDB Database -

Written SQL tutorials including exercises -

About Myself -

My Linkedin Page -

My Facebook Page -

SQL Platform Differences (comparing MySQL & Oracle) -
* Syntax covered in this lesson stays exactly the same on MySQL & Oracle

[alikhan-sujj]

hi, so why we are using set ANSI_NULLS on, when it has no benefit, because it does not work