Purpose: Tests for NULL values in a column.Syntax:
column_name IS NULL
or
column_name IS NOT NULL
Example:
SELECT * FROM employees WHERE department_id IS NULL;
Purpose: Tests for NULL values in a column.Syntax:
column_name IS NULL
or
column_name IS NOT NULL
Example:
SELECT * FROM employees WHERE department_id IS NULL;
Leave a Reply