Popular Posts

Thursday, August 18, 2011

Delete Duplicate record from Table.

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

No comments:

Post a Comment