By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 7
| column1 | timestamp |
|---|---|
| a | 1 |
| a | 2 |
| a | 3 |
| b | 4 |
| b | 5 |
| a | 6 |
| a | 7 |
SELECT 7
| column1 | timestamp |
|---|---|
| a | 1 |
| b | 4 |
| a | 6 |
SELECT 3
CREATE TABLE
INSERT 0 7
| column1 | timestamp |
|---|---|
| a | 1 |
| a | 2 |
| a | 3 |
| b | 4 |
| b | 5 |
| a | 6 |
| a | 7 |
SELECT 7
| column1 | timestamp |
|---|---|
| a | 1 |
| b | 4 |
| a | 6 |
SELECT 3