By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
AccountNo | RunKey | RunDate | Item | Value | PreValue | PreDate |
---|---|---|---|---|---|---|
12345 | 4 | 2017-06-22 | PromotionDate | 2017-06-21 | 2017-01-15 | 2017-06-21 |
12345 | 4 | 2017-06-22 | Salary | 65000 | 60000 | 2017-06-21 |
AccountNo | RunKey | RunDate | Item | Value |
---|---|---|---|---|
12345 | 2 | 2017-06-20 | Address,Salary,PromotionDate | 123 Main Street,60000,2017-01-15 |
12345 | 3 | 2017-06-21 | Address,Salary,PromotionDate | 123 Main Street,60000,2017-01-15 |
12345 | 4 | 2017-06-22 | Address,Salary,PromotionDate | 123 Main Street,65000,2017-06-21 |