WHERE with NOT operator in SQL - Step-by-Step Execution

Concept Flow - WHERE with NOT operator

Start Query

↓

Scan Table Rows

↓

Evaluate WHERE Condition

↓

Apply NOT Operator

↓

Include Row if NOT Condition is True

↓

Return Filtered Rows

↓

End Query

The query scans each row, checks the condition, reverses it with NOT, and includes rows where the reversed condition is true.

Execution Sample

SQL

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

This query selects all employees who are NOT in the Sales department.

Execution Table

Step	Row Data (Employee, Department)	Condition (Department = 'Sales')	NOT Condition Result	Include Row?
1	('Alice', 'Sales')	True	False	No
2	('Bob', 'HR')	False	True	Yes
3	('Charlie', 'Sales')	True	False	No
4	('Diana', 'IT')	False	True	Yes
5	('Eve', 'Marketing')	False	True	Yes
Exit	-	-	-	All rows processed

💡 All rows checked; rows included only if NOT condition is True

Variable Tracker

Variable	Start	After Row 1	After Row 2	After Row 3	After Row 4	After Row 5	Final
Condition (Department = 'Sales')	N/A	True	False	True	False	False	N/A
NOT Condition Result	N/A	False	True	False	True	True	N/A
Included Rows Count	0	0	1	1	2	3	3

Key Moments - 3 Insights

Why does the row with Department 'Sales' get excluded?

Because the condition Department = 'Sales' is True, applying NOT makes it False, so the row is not included (see execution_table rows 1 and 3).

What does the NOT operator do to the condition?

It reverses the condition's truth value: True becomes False, False becomes True, as shown in the 'NOT Condition Result' column.

Why are employees from 'HR', 'IT', and 'Marketing' included?

Their Department is not 'Sales', so the condition is False, NOT makes it True, so these rows are included (see rows 2, 4, 5).

Visual Quiz - 3 Questions

Look at the execution table, what is the NOT Condition Result for the row ('Bob', 'HR')?

A False

B True

C Unknown

D Null

💡 Hint

Check the 'NOT Condition Result' column for Step 2 in the execution_table.

At which step does the query decide NOT to include a row?

A When the condition is False

B When the NOT condition is True

C When the NOT condition is False

D When the condition is Null

💡 Hint

Look at the 'Include Row?' column and see when it says 'No' in the execution_table.

If the query was changed to WHERE NOT Department = 'HR', which employee would be excluded?

A Bob

B Alice

C Diana

D Eve

💡 Hint

NOT reverses the condition; check who belongs to 'HR' in the variable_tracker.

Concept Snapshot

WHERE with NOT operator:
- Syntax: WHERE NOT condition
- It reverses the condition's truth value
- Rows where condition is False become included
- Useful to exclude specific values
- Works row by row during query filtering

Full Transcript

This visual execution shows how the SQL WHERE clause with the NOT operator works. The query checks each row's Department value against 'Sales'. If the condition is True, NOT makes it False, so the row is excluded. If the condition is False, NOT makes it True, so the row is included. This way, the query returns all employees not in the Sales department. The execution table tracks each step, showing condition evaluation and inclusion decisions. The variable tracker follows condition values and how many rows are included as the query runs.