title: Add +1 to a value of a row everytime a new row is inserted in a sql table
body: <p>I have 3 columns in SQL table:
  Ex:</p>
  
  <pre><code>|| ID || Name    || Position ||
     1    Robert        1
     2    Superman      2
     3    Spiderman     1
     .     .            .
     .     .            .
    1080   Herry        1
  </code></pre>
  
  <p>and i want to select data from same table and insert integer same table with the help of following Command:</p>
  
  <pre><code>INSERT INTO Table1 (Name, Position)
  SELECT NAME, Position FROM Table1 WHERE ID IN (2,3)
  </code></pre>
  
  <p>The value(Table1.Position) of the newly created rows should not be same as the old one but start from 1 as soon as command will be called and increase(1) every time a new row will be added.
  For ex. : When i call following:</p>
  
  <pre><code>INSERT INTO Table1 (Name, Position)
  SELECT NAME, Position FROM Table1 WHERE ID IN (2,3)
  </code></pre>
  
  <p>The Table should look like this</p>
  
  <pre><code>|| ID || Name    || Position ||
     1    Robert        1
     2    Superman      2
     3    Spiderman     1
     .     .            .
     .     .            .
    1080   Herry        1
    1081   Superman     1
    1082   Spiderman    2
  </code></pre>
  
  <p>Position value can be anywhere between 1 and n. where n is dependent on the no. of rows inserted with the same command and increase by 1 and everytime again a new command will be called, the Position/n value should start from 1 and is not dependent on the recent/old/last row Position value. </p>