delete tblname where columname in (select columnname FROM tblname GRO

how to delete duplicate rows from table in sql server

Question Posted / suresh s

Answer Posted / suresh s

delete tblname where columname in (select columnname
FROM tblname GROUP BY columnname having count(columnname)
>=2)

Is This Answer Correct ?

25 Yes

30 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of stored procedure in sql server?

928

Can sql servers link to other servers like oracle?

890

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

How do you test your database? : sql server database administration

1062

Explain atomicity?

1123

What is the exact numeric data type in sql?

1056

Do you have any idea about the tcl commands?

1010

What do you understand by sql server agent?

1026

How do I start sql server 2017?

984

What is the use of @@spid?

1047

What is a data source or ds? : sql server analysis services, ssas

1051

What are the restrictions while creating batches in sql server?

1110

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

1087

What kind of problems occurs if we do not implement proper locking strategy?

1460

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

958