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 |