title: How to eliminate overlapping date ranges in SQL?
body: <p>I am trying to eliminate overlapping date ranges in the data set. A smaller data set that I will be used:</p>
  
  <p><img src="https://i.stack.imgur.com/cMpeI.jpg" alt="enter image description here"></p>
  
  <p>How would I eliminate the highlighted first row of data as it overlaps the other date ranges for that specific id?</p>