delete from table name having count(column name)>1 group by column nam

How to delete the duplicate rows from a table in SQL Server ??

Question Posted / himmat

Answer Posted / himmat

delete from table name
having count(column name)>1
group by column name

Is This Answer Correct ?

15 Yes

25 No

Please Help Members By Posting Answers For Below Questions

How to create an index on a view?

1058

What is implicit mode in sql server?

1086

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

896

Can we install sql server 2016 on windows 7?

1124

How to create function with parameter in sql server?

1094

What does REVERT do in SQL Server 2005?

947

What is sql server query analyzer?

1016

what authentication modes does sql server support? : Sql server database administration

1085

What is de-normalization and what are some of the examples of it?

967

What is the maximum size of a dimension? : sql server analysis services, ssas

1034

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

973

How to override dml statements with triggers?

1167

What is database replication?

1128

What is the osql utility?

948

Is INSTEAD OF trigger directly applicable to Table ?

1008