SQL Null Values

The SQL NULL value condition used to check a NULL value in a table if the query returns TRUE means the NULL value is found otherwise the query returns FALSE if the NULL values are not found.

This condition will work when a field is optional in a table suppose, to insert a new record in a table without adding a value to optional field then, the field will be saved with a NULL value.

NULL Value Syntax

Use IS NULL Operatoe to find NULL Values, and IS NOT NULL Operator to find NOT NULL values.

IS NULL Condition

SELECT Column_Name
FROM Table_Name
WHERE Column_Name IS NULL;

IS NOT NULL Condition

SELECT Column_Name
FROM Table_Name
WHERE Column_Name IS NOT NULL;

Difference Between IS NULL & IS NOT NULL

  • Use IS NULL condition to get the Null values in the SQL table.
  • IS NULL condition is used as the comparison operator in SQL.
  • IS NOT NULL condition used to test fro Non-Empty values.

Policy

GDATAMART.COM is optimized for learning & job information; The users try to improve your knowledge and practical experience through this site but we cannot warrant full correctness of all content... Learn More → | Sitemap →

© 2020 GDATAMART | All Rights Reserved