By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
KEY_ID | MIN(FROMDATE) | MAX(TODATE) |
---|---|---|
50 | 01-JAN-11 | 21-FEB-16 |
100 | 01-JAN-10 | 31-OCT-10 |
67 | 22-FEB-16 | 02-OCT-17 |
40 | 01-JUL-18 | 31-OCT-18 |
75 | 03-OCT-17 | 30-JUN-18 |
75 | 01-NOV-18 | 01-MAR-20 |