Delete Duplicate Columns

[sonia.sardana]

Create table info(comp_id int identity(101,1),comp_name varchar(50))
insert into info values('Progressive Ltd.')
insert into info values('Progressive Ltd.')
insert into info values('EliResearch')
insert into info values('Patni')
insert into info values('Accenture')
insert into info values('Accenture')
select * from info

I want to delete those entries from the table that have duplicate company names.
I m not getting it,Plz reply.

[deepuv04]

Create table info(comp_id int identity(101,1),comp_name varchar(50))
insert into info values('Progressive Ltd.')
insert into info values('Progressive Ltd.')
insert into info values('EliResearch')
insert into info values('Patni')
insert into info values('Accenture')
insert into info values('Accenture')
select * from info

I want to delete those entries from the table that have duplicate company names.
I m not getting it,Plz reply.

hi
try the following query

DELETE FROM [info] 
WHERE [comp_name] IN
(SELECT [comp_name] FROM [info] 
GROUP BY [comp_name] HAVING COUNT([comp_name]) > 1)
 

[sonia.sardana]

Thanks,
it worked.