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 | 335 |
| 00001 | 2001-04-02 | 010104 | 3573 | 2003-07-15 | 834 |
| 00001 | 2003-07-15 | 010106 | 3833 | 2006-05-01 | 1021 |
| 00001 | 2006-05-01 | 011112 | 7120 | 2006-10-25 | 177 |
| 00001 | 2006-10-25 | 010108 | 3835 | 2007-04-20 | 177 |
| 00001 | 2007-04-20 | 011112 | 7120 | 2007-11-12 | 206 |
| 00001 | 2007-11-12 | 010410 | 4301 | 2008-02-01 | 81 |
| 00001 | 2008-02-01 | 010443 | 4334 | null | null |