title: SQL How to insert a new row in the middle of the table
body: <p>Here is my problem:</p>
  
  <p>I want to insert a new row in my table but there is already some registers in it. If I need to put this new row at the same row that a already register is, what should I do?</p>
  
  <p>For example:</p>
  
  <p>I have this table with this rows:</p>
  
  <pre><code>ID|Value
  1 |Sample1
  2 |Sample2
  3 |Sample3
  </code></pre>
  
  <p>But now I want to insert a new row where Sample2 is, so the table should be like:</p>
  
  <pre><code>ID|Value
  1 |Sample1
  2 |NewSample
  3 |Sample2
  4 |Sample3
  </code></pre>
  
  <p>Any thoughts?</p>