I have to perform a validation using sql in which a range of dates is not between another range of dates, for example:
- first validation range: 06-Jul-2018/15-Jul-2018
- second rank: 07-Jul-208/12-Jul-2018
- third rank: 01-Jul-2018/8-Jul-2018
- fourth rank: 10-Jul-2018/20-Jul-2018
The first rank I have saved in database and my query will enter the values of ranges 2,3 and 4. and I must return the record of the first rank to validate that those ranges overlap with the first.
I've broken my head a lot and I have not found a solution yet.
Thank you.