GROUP BY with NULL values behavior in SQL - Step-by-Step Execution

Concept Flow - GROUP BY with NULL values behavior

Start with table data

↓

Identify column to GROUP BY

↓

Check each row's GROUP BY value

↓

Group rows with same value, including NULLs

↓

Aggregate or list grouped rows

↓

Return grouped result set

The database groups rows by the specified column, treating NULLs as a single group.

Execution Sample

SQL

SELECT category, COUNT(*) FROM products GROUP BY category;

Groups products by category, counting how many products are in each category, including those with NULL category.

Execution Table

Step	Row	category value	Group assigned	Group count so far
1	Row 1	'Electronics'	Group 'Electronics'	1
2	Row 2	'Clothing'	Group 'Clothing'	1
3	Row 3	NULL	Group NULL	1
4	Row 4	'Electronics'	Group 'Electronics'	2
5	Row 5	NULL	Group NULL	2
6	Row 6	'Clothing'	Group 'Clothing'	2
7	Row 7	'Toys'	Group 'Toys'	1
8	End	-	-	-

💡 All rows processed; groups formed including NULL group.

Variable Tracker

Variable	Start	After 1	After 2	After 3	After 4	After 5	After 6	After 7	Final
Group 'Electronics' count	0	1	1	1	2	2	2	2	2
Group 'Clothing' count	0	0	1	1	1	1	2	2	2
Group NULL count	0	0	0	1	1	2	2	2	2
Group 'Toys' count	0	0	0	0	0	0	0	1	1

Key Moments - 2 Insights

Why are NULL values grouped together instead of ignored or treated separately?

In the execution_table rows 3 and 5 show NULL values assigned to the same group 'Group NULL', because SQL treats all NULLs as one group in GROUP BY.

Does GROUP BY treat NULL as equal to any other value?

No, as shown in execution_table, NULLs form their own group distinct from any non-NULL value groups.

Visual Quiz - 3 Questions

Look at the execution_table at step 5, what is the group count for NULL values?

A 1

B 2

C 0

D 3

💡 Hint

Check the 'Group count so far' column at step 5 for the NULL group.

At which step does the 'Toys' group first appear in the execution_table?

A Step 4

B Step 5

C Step 7

D Step 3

💡 Hint

Look for the first row where 'Group 'Toys'' is assigned.

If the NULL values were not grouped together, how would the variable_tracker change?

A There would be multiple NULL groups with counts of 1 each

B NULL group count would be zero

C NULL group count would be combined with 'Electronics'

D NULL group count would be the same as shown

💡 Hint

Consider how grouping treats NULLs as one group in variable_tracker.

Concept Snapshot

GROUP BY groups rows by column values.
NULL values are grouped together as one group.
Each group aggregates rows sharing the same value or NULL.
Result shows one row per group including NULL group.
Useful to count or summarize data by categories including NULL.

Full Transcript

This visual execution shows how SQL GROUP BY works with NULL values. Each row is checked for the grouping column value. Rows with the same value form a group. Rows with NULL in the grouping column form a single NULL group. The execution table traces each row's group assignment and counts. The variable tracker shows how group counts update step-by-step. Key moments clarify that NULLs are treated as equal for grouping, forming one group. The quiz tests understanding of group counts and NULL grouping behavior. The snapshot summarizes that GROUP BY includes NULLs as one group in results.