By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| no | name | date1 |
|---|---|---|
| 1 | AAA | 01/01/2019 00:00:00 |
| 2 | BBB | 01/01/2019 00:00:00 |
| 1 | AAA | 02/02/2019 00:00:00 |
| 2 | BBB | 02/02/2019 00:00:00 |
| no | name | date1 |
|---|---|---|
| 1 | AAA | 01/01/2019 00:00:00 |
| 2 | BBB | 01/01/2019 00:00:00 |
| 1 | AAA | 02/02/2019 00:00:00 |
| 2 | BBB | 02/02/2019 00:00:00 |