title: How to identify duplicate rows having value within data range in oracle
body: <p>I want to identify rows where value in Name column is same and value in start/ end column lies within range of Start and End value of another row...
  for eg. for me row with ID value 4 &amp; 1 are duplicate because they have same value in Name column and value in start column 26 of ID 4 lies within start &amp; End values of ID 1 (24-56)  </p>
  
  <p><strong>ID    Name    Start   End</strong></p>
  
  <p><em>1  Adam    24  56</em></p>
  
  <p>2   Max 1   5</p>
  
  <p>3   Neil    6   4</p>
  
  <p><em>4  Adam    26  30</em></p>