create table missing_data(sno varchar(3)primary key,name varchar(15),designation char(10))
insert into missing_data values(1,'riz','SE'),(2,'sandy','SE'),(3,'sharein','SE'),(4,'chithu','SE'),(5,'flora','SE'),(6,'gayu','SD'),(7,'maha','SD'),(8,'moni','SD'),(9,'maddy','AE'),(10,'naz','AE')
select * from missing_data order by sno
delete from missing_data where name='gayu'
What I have tried:
I had deleted name='gayu' in the above table and i want sno = 6 to appear on the table after delete with null values in the row without affecting sequence.. is that possible in sql table???