By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| emcd | efdt | sikeyid | sicd | PreviousDay | (No column name) |
|---|---|---|---|---|---|
| 00001 | 2000-05-02 | 011116 | 7151 | 2001-04-02 | 334 |
| 00001 | 2001-04-02 | 010104 | 3573 | 2003-07-15 | 833 |
| 00001 | 2003-07-15 | 010106 | 3833 | 2006-05-01 | 1020 |
| 00001 | 2006-05-01 | 011112 | 7120 | 2006-10-25 | 176 |
| 00001 | 2006-10-25 | 010108 | 3835 | 2007-04-20 | 176 |
| 00001 | 2007-04-20 | 011112 | 7120 | 2007-11-12 | 205 |
| 00001 | 2007-11-12 | 010410 | 4301 | 2008-02-01 | 80 |
| 00001 | 2008-02-01 | 010443 | 4334 | null | null |