IS NULL Operator in SQL Query with Example
SQL IS NULL Operator:
A column value is NULL if it does not exist. The IS NULL operator is used to display all the rows for columns that do not have a value.
For Example: If you want to find the emp names who do not get any commision, the query would be as given below:
select * from emp where COMM IS NULL;
In the opposite way, NOT NULL also works here:
select * from emp where COMM IS NOT NULL;
Thanks for watching..:)