Range partition

Partition by a value range.

Range partition

Range partition splits by value range. Ideal for date ranges.

CREATE TABLE sales (...) PARTITION BY RANGE (sale_date);
CREATE TABLE sales_2026_q1 PARTITION OF sales
  FOR VALUES FROM ('2026-01-01') TO ('2026-04-01');

Partition for Q1 2026.

The table sales is created.

Range partition — details

Range partition defines ranges with FROM and TO. Each range is a separate partition.

For example, FOR VALUES FROM ('2026-01-01') TO ('2027-01-01') covers the year 2026; the end value is excluded, so ranges don't overlap.

Exercise Range partition

Create the sales_2026_q1 partition with FOR VALUES FROM ('2026-01-01') TO ('2026-04-01').

Show example solution

CREATE TABLE sales_2026_q1 PARTITION OF sales
  FOR VALUES FROM ('2026-01-01') TO ('2026-04-01');

Test yourself

Add RANGE

PARTITION BY ____ (sale_date)

Show answer

PARTITION BY RANGE (sale_date)

What does range partition split by?
- A list
- Color
- A hash
- A range of values
Show answer

A range of values — Range partition splits by value range.
Range partition: match the terms

RANGE

range
FROM

start
TO

end
date

partition

Next lesson: List partition

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies