By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ID | NO | DIA |
---|---|---|
20210101 | A01 | 100 |
20210101 | A02 | 200 |
20210102 | A01 | 100 |
20210103 | A01 | 100 |
20210103 | A01 | 100 |
ID | NO | DIA |
---|---|---|
20210102 | X01 | 100 |
20210102 | X02 | 150 |
ID | NO | DIA |
---|---|---|
20210101 | A01 | 100 |
20210101 | A02 | 200 |
20210102 | X01 | 100 |
20210102 | X02 | 150 |
20210103 | A01 | 100 |
20210103 | A01 | 100 |