title: Grouping SQL results by continuous time intervals (oracle sql)
body: <p>Hi I have following data in the table:</p>
  
  <p>ID-----startDate----endDate<br>
      5549    2008-05-01  4712-12-31<br>
      <strong>5567  2008-04-17  2008-04-30  1<br>
      5567    2008-05-01  2008-07-31  1<br>
      5567    2008-09-01  4712-12-31  2</strong><br>
      5569    2008-05-01  2008-08-31<br>
      5569    2008-09-01  4712-12-31<br>
      5589    2008-04-18  2008-04-30<br>
      5589    2008-05-01  4712-12-31<br>
      5667    2008-05-01  4712-12-31<br>
      5828    2008-06-03  4712-12-31<br>
      5867    2008-06-03  4712-12-31<br>
      6167    2008-11-01  4712-12-31<br>
      6207    2008-07-01  4712-12-31<br>
      6228    2008-07-01  4712-12-31<br>
      6267    2008-07-14  4712-12-31</p>
  
  <p>I am looking for I way to group the continuous time intervals for each id to return:</p>
  
  <p>ID,
  min(startDate),
  max(endDate),</p>
  
  <p>to have  something like this in result for the bolded ID 5567   </p>
  
  <p>5567    2008-04-17  2008-07-31<br>
  5567    2008-09-01  4712-12-31  </p>
  
  <p>PL/SQL is also an option here :)</p>
  
  <p>Thanks,</p>