title: Select next row
body: <p>I would like to concatenate two text fields from the current row with the same field from the next row</p>
  
  <p>So if the table is like</p>
  
  <pre><code>field1  field2  field3
  
  text1    text3  order1
  text2    text4  order1
  </code></pre>
  
  <p>i would like to do this:</p>
  
  <pre><code>if (field3.current_row = field3.next_row)
       SELECT field1 + getNextRow(field1) as "Concatenated Field" FROM table
  </code></pre>
  
  <p>Is this possible?</p>