COUNT function in MySQL - Step-by-Step Execution

Concept Flow - COUNT function

Start Query

↓

Scan Table Rows

↓

Check Condition (if any)

Yes No↓

Include Row

↓

Count Included Rows

↓

Return Count Result

↓

End

The COUNT function scans table rows, includes those matching conditions, counts them, and returns the total count.

Execution Sample

MySQL

SELECT COUNT(*) FROM employees WHERE department = 'Sales';

Counts how many employees work in the Sales department.

Execution Table

Step	Row ID	Department	Condition (department='Sales')	Include in Count?	Running Count
1	1	Sales	True	Yes	1
2	2	HR	False	No	1
3	3	Sales	True	Yes	2
4	4	Marketing	False	No	2
5	5	Sales	True	Yes	3
6	6	HR	False	No	3
7	7	Sales	True	Yes	4
Exit	-	-	-	-	Final count = 4

💡 All rows scanned; count returned for rows where department = 'Sales'

Variable Tracker

Variable	Start	After 1	After 2	After 3	After 4	Final
Running Count	0	1	1	2	3	4

Key Moments - 2 Insights

Why does the count not increase for rows where the department is not 'Sales'?

Because the condition department='Sales' is false for those rows, so they are skipped and not included in the count, as shown in steps 2, 4, and 6 in the execution_table.

What does COUNT(*) count exactly?

COUNT(*) counts all rows that meet the condition, regardless of NULL values in any column. Here, it counts all rows where department='Sales', as seen in the included rows in the execution_table.

Visual Quiz - 3 Questions

Look at the execution_table, what is the Running Count after step 3?

A 3

B 1

C 2

D 0

💡 Hint

Check the 'Running Count' column at step 3 in the execution_table.

At which step does the condition department='Sales' become false for the first time?

A Step 2

B Step 1

C Step 4

D Step 5

💡 Hint

Look at the 'Condition' column in the execution_table to find the first 'False'.

If the WHERE clause was removed, what would the final count be after scanning 7 rows?

A 0

B 7

C 4

D 3

💡 Hint

Without a condition, COUNT(*) counts all rows scanned, so check the total number of rows in the execution_table.

Concept Snapshot

COUNT function syntax: COUNT(*) or COUNT(column)
Counts rows matching optional conditions
Ignores NULLs if counting a specific column
Returns a single number
Useful for totals and summaries

Full Transcript

The COUNT function in SQL counts how many rows match a condition. It scans each row in the table, checks if it meets the condition, and if yes, adds one to the count. For example, counting employees in the Sales department scans all employees, includes only those with department='Sales', and returns the total count. Rows not matching the condition are skipped and do not increase the count. COUNT(*) counts all rows regardless of NULLs. This visual trace shows step-by-step how rows are checked and counted, helping beginners understand how COUNT works internally.