By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| id | START_DATE | END_DATE | feature |
|---|---|---|---|
| 001 | 01/08/1995 00:00:00 | 31/12/1997 00:00:00 | 1 |
| 001 | 01/01/1998 00:00:00 | 31/03/2017 00:00:00 | 4 |
| 001 | 14/06/2000 00:00:00 | 31/03/2017 00:00:00 | 45 |
| 001 | 01/04/2013 00:00:00 | 31/03/2017 00:00:00 | 458 |
| 002 | 01/10/1929 00:00:00 | 25/05/2006 00:00:00 | 1 |
| 002 | 26/05/2006 00:00:00 | 10/11/2016 00:00:00 | 47 |
| 002 | 01/04/2013 00:00:00 | 10/11/2016 00:00:00 | 478 |