# SQL: Insert between two rows

**URL:** <https://forum.kirupa.com/t/sql-insert-between-two-rows/300499>\
**Category:** programming\
**Created:** [November 22, 2009, 4:24pm UTC](https://forum.kirupa.com/t/sql-insert-between-two-rows/300499 "2009-11-22T16:24:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kadaj](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/kadaj/32/9061_2.png) [@kadaj](https://forum.kirupa.com/u/kadaj)\
**Post date:** [November 22, 2009, 4:24pm UTC](https://forum.kirupa.com/t/sql-insert-between-two-rows/300499/1 "2009-11-22T16:24:35Z")

</div>

How to insert between two rows.  
My table has 3 columns–\> id, req, res  
id begins with 1.  
how to insert at id =10 , a new values for req and res.  
The already present values must then have the next id. i.e id+1.

Please help.  
Thank You.