how to select null and not null values in sql code example

Example 1: find value if not null in sql

SELECT FIRST_NAME , MANAGER_ID 
FROM EMPLOYEES 
WHERE MANAGER_ID IS NOT NULL ;

Example 2: Select without null values sql

SELECT column_names
FROM table_name
WHERE column_name IS NOT NULL;