IS NOT NULL condition checks for NOT NULL values. IS NOT NULL condition is used to fetch rows or columns which are having valid values. IS NOT NULL condition is used in SELECT, UPDATE, DELETE statements.

SELECT column1, column2, …, columnN
FROM table_name
WHERE column_name IS NOT NULL; 

UPDATE table_name
 SET column1 = value1, column2 = value2, …, columnN = valueN
 WHERE column_name IS NOT NULL; 

DELETE FROM table_name
 WHERE column_name IS NOT NULL; 

• column1, column2, …, columnN - Specifies the column names from table.
• table_name – Specifies the name of the table.
• column-name - Specifies the column that used to check not NULL values.

Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.

Scenario – Fetch rows using IS NOT NULL Condition.

Requirement – Fetch all details of employees whose manager_id IS NOT NULL. The query was as follows –

SELECT * FROM employee_details WHERE manager_id IS NOT NULL; 

By executing above query, we can get results as shown below –

Scenario – Update the rows using IS NOT NULL condition.

Requirement - Update the salary as 18000 for the employee who have valid manager updated and designation is "Clerk". The query was as follows –

UPDATE employee_details SET salary = 18000 
 WHERE manager_id IS NOT NULL AND designation= "Clerk"; 

By executing above query, we can update the salary for the employee who have valid manager updated and designation is "Clerk". The updated table was as follows-

Scenario – Delete rows using IS NOT NULL condition.

Requirement – Delete employee details who has manager updated. The query was as follows –

DELETE FROM employee_details 
WHERE emp_id = 009 AND manager_id IS NOT NULL; 

By executing above query, we can delete rows who has valid manager. The output was as follows -