add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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