Loading

Arrange the SNO after Delete Query Execute

Veeramanikandan Dhanabalan

15y2.3kSQL

I have a table name employees in that i have three columns named id , srno , and empname there are total 100 employee name in the table with tier respected id number now what i want that if an employee leaves the company the data relate to him or her should be deleted but at the same time sr no should be re arrange in proper format fo e.g
sr no
1
2
3
4
now when i delete sr no" 3 " sr no "4" should be converted to "3" and this loop should go till sr no "100"

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
First of all its not a good way to handle the logic. Just do a soft delete like having a column "Active" with default value as 'Y' and change to 'N' if the employee leaves the company. The advantage of this is you can still maintain the employee details for future reference.
0