By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 3 Duplicates: 0 Warnings: 0
| @range_start | min(unit) - 1 |
|---|---|
| 1000 | 1002 |
| 1003 | 1003 |
| 1004 | 4000 |
| 1008 | 1008 |
| 1009 | 4000 |
| 4000 | 4000 |
| 4001 | 9000 |
Records: 3 Duplicates: 0 Warnings: 0
| @range_start | min(unit) - 1 |
|---|---|
| 1000 | 1002 |
| 1003 | 1003 |
| 1004 | 4000 |
| 1008 | 1008 |
| 1009 | 4000 |
| 4000 | 4000 |
| 4001 | 9000 |