create table t1(id int,na varchar(30))
Go
insert into t1 select 1,'Jon'
insert into t1 select 2,'Raj'
insert into t1 select 1,'Jon'
insert into t1 select 3,'SK'
GO
select * from t1
GO
delete top(1) from t1 where id=1
Go
insert into t1 select 1,'Jon'
insert into t1 select 2,'Raj'
insert into t1 select 1,'Jon'
insert into t1 select 3,'SK'
GO
select * from t1
GO
delete top(1) from t1 where id=1