By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | MIN(T1.SEENAT)OVER(PARTITIONBYT1.IDORDERBYT1.ID) | SEENAT |
|---|---|---|
| 1 | 20 | 20 |
| 1 | 20 | 21 |
| 1 | 20 | 22 |
| 2 | 70 | 70 |
| 2 | 70 | 80 |
| ID | MIN(T1.SEENAT)OVER(PARTITIONBYT1.IDORDERBYT1.ID) | SEENAT |
|---|---|---|
| 1 | 20 | 20 |
| 1 | 20 | 21 |
| 1 | 20 | 22 |
| 2 | 70 | 70 |
| 2 | 70 | 80 |