Table Name - Student
SNO Name Address
1 Shatrughan Bilaspur
2 Anup Mumbai
3 Shankar Delhi
and After Perform this query :- Delete from Student Where SNO=2 ;
Table look like this
SNO Name Address
1 Shatrughan Bilaspur
3 Shankar Delhi
But I want to rearrange the table like
SNO Name Address
1 Shatrughan Bilaspur
2 Shankar Delhi
Thanks for reading.....