By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
DAY_FROM | DAY_TO | VEND_LOY_ACCT_DW_ID | HUB_CUST_ID | CUR_LOY_TIER_DW_ID |
---|---|---|---|---|
24-SEP-14 | 22-OCT-14 | 71047795 | 476095 | 3103 |
01-OCT-14 | 22-OCT-14 | 71047795 | 476095 | 3103 |
08-OCT-14 | 22-OCT-14 | 71047795 | 476095 | 3103 |
15-OCT-14 | 22-OCT-14 | 71047795 | 476095 | 3103 |
22-OCT-14 | 12-NOV-15 | 71047795 | 476095 | 3102 |
29-OCT-14 | 12-NOV-15 | 71047795 | 476095 | 3102 |
05-NOV-15 | 12-NOV-15 | 71047795 | 476095 | 3102 |
12-NOV-15 | 31-DEC-99 | 71047795 | 476095 | 3103 |
VERSION | CURRENT_FLAG | DAY_FROM | DAY_TO | VEND_LOY_ACCT_DW_ID | HUB_CUST_ID | CUR_LOY_TIER_DW_ID |
---|---|---|---|---|---|---|
1 | N | 24-SEP-14 | 22-OCT-14 | 71047795 | 476095 | 3103 |
2 | N | 22-OCT-14 | 12-NOV-15 | 71047795 | 476095 | 3102 |
3 | Y | 12-NOV-15 | 31-DEC-99 | 71047795 | 476095 | 3103 |