Please help me, it's urgent.
I have below table. after insert data it looks like this.
Id Name Age
-----------------------------
1 Manoj 23
2 Rahul 25
3 Rohit 22
4 Sunita 24
After delete one record,
Id Name Age
-----------------------------
1 Manoj 23
2 Rahul 25
4 Sunita 24
After delete one row, i want auto reset id column . how i will solve this problem. please help me.
Id Name Age
-----------------------------
1 Manoj 23
2 Rahul 25
3 Sunita 24
Thanks & Regards
Manoj Kumar