find Overlapping sql code example

Example 1: find Overlapping sql

SELECT e.* FROM table_e e WHERE
start_value BETWEEN e.start AND e.end
OR (start_value <= e.start AND end_value >= e.end);

Example 2: check if two date ranges overlap sql server

(StartDate1 <= EndDate2) and (StartDate2 <= EndDate1)