SQL Server NOT Condition (Operator)

The SQL Server NOT condition or NOT operator is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement.

Syntax:

NOT condition   

Parameter explanation

condition: It specifies the condition that you want to negate.

NOT Operator with IN condition

We have a table “Employees”, having the following data:

Example

Retrieve all employees from the table where the following “NOT” condition is satisfied:

SELECT *  

FROM [javatpoint].[dbo].[Employees]  

WHERE name NOT IN ('Mahesh', 'Mohan', 'Chitra');

Output:

NOT Operator with IS NULL condition

Retrieve all employees from the table “Employees” which follows the IS NOT NULL condition:

SELECT *  

FROM [javatpoint].[dbo].[Employees]  

WHERE name IS NOT NULL;

Output:

NOT Operator with LIKE condition

Retrieve all employees from the table “Employees” which follows the NOT LIKE condition. It will display only names which don?t start with “M”.

SELECT *  

FROM [javatpoint].[dbo].[Employees]  

WHERE name NOT LIKE 'M%';

Output:

NOT Operator with BETWEEN condition

Retrieve all employees from the table “Employees”, which follows the following condition. It will not show the employees between the id 8 to 13.

SELECT *  

FROM [javatpoint].[dbo].[Employees]  

WHERE id NOT BETWEEN 8 AND 13;

Output:

Or:

SELECT *  

FROM [javatpoint].[dbo].[Employees]  

WHERE id < 8  

OR id > 13;

Output:

NOT Operator with EXISTS condition

You can also combine SQL Server NOT condition with the EXISTS condition.

OR condition:

SELECT *  

FROM [javatpoint].[dbo].[Employees]  

WHERE NOT EXISTS (SELECT *  

                  FROM [javatpoint].[dbo].[Employee2]  

                  WHERE Employees.name = Employee2.name  

                  OR Employees.salary = Employee2.salary);

Output:

AND Condition:

SELECT *  

FROM [javatpoint].[dbo].[Employees]  

WHERE NOT EXISTS (SELECT *  

                  FROM [javatpoint].[dbo].[Employee2]  

                  WHERE Employees.name = Employee2.name  

                  AND Employees.salary = Employee2.salary);

Output:

This SQL Server NOT example would return all records from the Employees table where there are no records in the Employee2 table for the matching name and salary.