By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
20 rows affected
| id | enc_id | ord_dt | enc_id |
|---|---|---|---|
| 1 | 1 | 2020-03-07 | 5 |
| 1 | 2 | 2020-04-14 | 5 |
| 1 | 3 | 2020-05-15 | 5 |
| 1 | 4 | 2020-05-30 | 5 |
| 1 | 5 | 2020-06-12 | 5 |
| 1 | 1 | 2020-03-07 | 6 |
| 1 | 2 | 2020-04-14 | 6 |
| 1 | 3 | 2020-05-15 | 6 |
| 1 | 4 | 2020-05-30 | 6 |
| 1 | 5 | 2020-06-12 | 6 |
| 1 | 6 | 2021-07-21 | 6 |
| 1 | 1 | 2020-03-07 | 7 |
| 1 | 2 | 2020-04-14 | 7 |
| 1 | 3 | 2020-05-15 | 7 |
| 1 | 4 | 2020-05-30 | 7 |
| 1 | 5 | 2020-06-12 | 7 |
| 1 | 6 | 2021-07-21 | 7 |
| 1 | 7 | 2021-09-15 | 7 |
| 2 | 1 | 2020-04-15 | 2 |
| 2 | 2 | 2020-04-21 | 2 |
| 2 | 1 | 2020-04-15 | 5 |
| 2 | 2 | 2020-04-21 | 5 |
| 2 | 3 | 2020-04-30 | 5 |
| 2 | 4 | 2020-05-02 | 5 |
| 2 | 5 | 2020-05-05 | 5 |