By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 3 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
ID | NAME | DATE |
---|---|---|
1 | a | 2020-01-01 |
2 | b | 2020-01-01 |
3 | c | 2020-01-01 |
ID | VALUE | DATE |
---|---|---|
1 | 100 | 2020-05-01 |
1 | 200 | 2020-04-01 |
1 | 300 | 2020-03-01 |
ID | NAME | DATE | VALUE |
---|---|---|---|
1 | a | 2020-01-01 | 100 |
ID | NAME | DATE | VALUE |
---|---|---|---|
1 | a | 2020-01-01 | 100 |
2 | b | 2020-01-01 | null |
3 | c | 2020-01-01 | null |