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

Explain about Joins?

969

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1238

What is sql server transaction log file?

1035

How can i Relate Tables in SSIS

1065

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

992

Which are the important points to note when multilanguage data is stored in a table?

973

What are the options which must be set to allow the usage of optimistic models?

946

What is the difference between a function and a trigger?

1061

Can you explain various data region available in ssrs with their use?

962

What is difference statement and preparedstatement?

963

What is the server name for sql management studio?

999

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

939

What is database replication? What are the different types of replication you can set up in sql server?

946

What is msdb database? : SQL Server Architecture

1111

What is log in sql server?

1125