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.
9 rows affected
CLIENTID GRP RN STARTDATE ENDDATE
1 0 1 10-OCT-17 12-OCT-17
1 0 2 12-OCT-17 13-OCT-17
1 0 3 13-OCT-17 17-OCT-17
1 1 4 10-NOV-17 17-NOV-17
1 0 5 17-NOV-17 23-NOV-17
1 1 6 12-DEC-17 14-DEC-17
2 1 7 10-NOV-17 15-NOV-17
2 1 8 01-DEC-17 02-DEC-17
2 0 9 02-DEC-17 05-DEC-17
CLIENTID GRP RN STARTDATE ENDDATE SM
1 0 1 10-OCT-17 12-OCT-17 0
1 0 2 12-OCT-17 13-OCT-17 0
1 0 3 13-OCT-17 17-OCT-17 0
1 1 4 10-NOV-17 17-NOV-17 1
1 0 5 17-NOV-17 23-NOV-17 1
1 1 6 12-DEC-17 14-DEC-17 2
2 1 7 10-NOV-17 15-NOV-17 3
2 1 8 01-DEC-17 02-DEC-17 4
2 0 9 02-DEC-17 05-DEC-17 4
CLIENTID STARTDATE ENDDATE
1 10-OCT-17 17-OCT-17
1 10-NOV-17 23-NOV-17
1 12-DEC-17 14-DEC-17
2 10-NOV-17 15-NOV-17
2 01-DEC-17 05-DEC-17