title: Oracle - Group By with "steps"
body: <p>I have to following table:</p>
  
  <pre><code>|MY_VALUES|
  |---------|
  | 1       | 1' iteration
  | 3       | 1' iteration   | 2' iteration
  | 2       | 1' iteration   | 2' iteration   | 3' iteration
  | 5       | 1' iteration   | 2' iteration   | 3' iteration
  | 3       | 1' iteration   | 2' iteration   | 3' iteration
  | 2       |                | 2' iteration   | 3' iteration
  | 4       |                                 | 3' iteration
  </code></pre>
  
  <p>I need a query which output is the following:</p>
  
  <pre><code>MY_RESULTS
  ----------
  14
  15
  16
  </code></pre>
  
  <p>The query is basically summing the first 5 rows for the first result, then it goes forward of one value and it sums the other 5 and so on...</p>
  
  <p>Is there a way to do it with Oracle? I cannot find on the documentation anything for doing such work.</p>