SQL NOT Operator – Complete Beginner's Guide with Examples (2026)

✅ What is the SQL NOT Operator?

✅ The SQL NOT operator is a logical operator that reverses the result of a condition in a WHERE clause.

✅ It returns rows where the condition evaluates to FALSE — in other words, it excludes the matching rows instead of including them.

✅ NOT can be combined with IN, LIKE, BETWEEN, IS NULL, and comparison operators like =, >, <.

✅ Sample Employees Table used in all examples below:-

✅ SQL NOT Syntax

SELECT column1, column2, ...
FROM table_name
WHERE NOT condition;

✅ SELECT:- Columns you want to retrieve.

✅ FROM:- The table to query data from.

✅ WHERE:- Starts the filtering section.

✅ NOT:- Reverses the condition — returns rows where the condition is FALSE.

✅ All Forms of SQL NOT – Quick Reference Table

✅ Example 1 – NOT Equal (WHERE NOT)

Retrieve all employees who are NOT in the IT department.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE NOT Department = 'IT';

✅ Result:-

✅ Example 2 – NOT IN

Retrieve all employees whose name is NOT in a given list. NOT IN is more efficient than chaining multiple != conditions.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE Name NOT IN ('ANNI', 'RAJ');

✅ Result:-

✅ Example 3 – NOT BETWEEN

Retrieve all employees whose salary falls outside the range 5000 to 9000.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE Salary NOT BETWEEN 5000 AND 9000;

✅ Result:-

✅ Example 4 – NOT LIKE

Retrieve all employees whose name does NOT start with the letter 'A'. NOT LIKE is the opposite of the LIKE pattern-matching operator.

✅ SELECT Query:-

SELECT * FROM Employees
WHERE Name NOT LIKE 'A%';

✅ Result:-

✅ Example 5 – IS NOT NULL

Retrieve all employees who have an email address (i.e. the Email column is not empty).

✅ SELECT Query:-

SELECT * FROM Employees
WHERE Email IS NOT NULL;

✅ Result:-

✅ Example 6 – NOT Combined with AND / OR

Use NOT with parentheses to negate an entire group of conditions at once.

✅ SELECT Query – Exclude both IT and HR departments:-

SELECT * FROM Employees
WHERE NOT (Department = 'IT' OR Department = 'HR');

✅ Result:-

✅ SELECT Query – NOT with AND condition:-

SELECT * FROM Employees
WHERE NOT Department = 'IT'
  AND Salary > 6000;

✅ Result:-

✅ Key Points to Remember

✅ NOT reverses any condition — it returns rows where the condition is FALSE.

✅ Works with any operator — NOT IN, NOT LIKE, NOT BETWEEN, IS NOT NULL, and plain NOT.

✅ Use IS NOT NULL — never != NULL — NULL cannot be compared with = or !=.

✅ Use parentheses when combining NOT + AND/OR — prevents logic errors and makes intent clear.

✅ NOT IN vs multiple != — NOT IN ('A','B','C') is cleaner than != 'A' AND != 'B' AND != 'C'.

✅ NOT BETWEEN excludes endpoints — both the lower and upper bounds are excluded from results.

✅ NOT LIKE uses wildcards — % matches any characters, _ matches a single character.

✅ Common SQL NOT Mistakes to Avoid