Check if there are similar rows in a table
this would be exact

select min(id), max(id)  
from table 
group by start_da, end_date 
having count(*) &gt; 1


start in

select t1.*, t2*
from table t1 
join table t2
      on t1.startdate between t2.startdate and t2.end_date