By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
exdate | vendor | product |
---|---|---|
2021-08-01 | 01 | 蘋果 |
2021-08-02 | 01 | 芭樂 |
2021-08-03 | 01 | 水蜜桃 |
2021-09-01 | 01 | 蘋果 |
2021-09-02 | 01 | 西瓜 |
2021-09-03 | 01 | 香蕉 |
2021-08-05 | 01 | 番茄 |
2021-08-01 | 02 | 蘋果 |
2021-08-02 | 02 | 芭樂 |
2021-08-03 | 02 | 水蜜桃 |
YearMonth | vendor | product | product2 |
---|---|---|---|
202108 | 01 | 蘋果 | 芭樂 |
202109 | 01 | 蘋果 | 西瓜 |
202108 | 02 | 蘋果 | 芭樂 |