title: In SQL, how to combine two sequential rows into one when no common ID?
body: <p>Have values split between multiple records without a key to join them.  The order is sequential.</p>
  <p>Current SQL table contents:</p>
  <pre><code>RowNum    Value
  1         10343  
  2         20784
  3         34523
  4         22415
  5         31245
  6         11345
  7         24588 
  8         32946
  </code></pre>
  <p>I want to return rows combining the two consecutive records but only those with Values starting with 2 and 3.  There is no common column value to group on.</p>
  <p>Desired result:</p>
  <pre><code>RowNums   Values
  2-3       20784, 34523
  4-5       22415, 31245
  7-8       24588, 32946
  </code></pre>