By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
person_id | company_id | entry_date | exit_date |
---|---|---|---|
1 | 24 | 2004-03-17 | 2010-12-31 |
2 | 24 | 2011-04-18 | 2019-11-28 |
3 | 25 | 2017-02-10 | 2019-10-20 |
4 | 34 | 2004-03-17 | 2010-12-31 |
5 | 24 | 2004-03-17 | 2999-01-01 |
6 | 24 | 2010-03-20 | 2999-01-01 |