how to delete duplicate rows from table in sql server
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 |
Post New Answer View All Answers
What is the difference between count and distinct count?
What are the features of Embedded SQL
Can two different columns be merged into single column? Show practically?
What is the contrast amongst drop and truncate?
Which is the latest version of sql server and when it is released?
What are different type of Collation Sensitivity?
What is 5nf in normalization form?
Differentiate between delete and truncate.
Do you know what is normalization of database? What are its benefits?
What are the different sql server versions?
Which data type columns are the best candidates for full-text indexing?
What are the components of dbms?
What are the different types of Indexes available in SQL Server?
What is the command dbcc checkdb used for?
Can we do dml on views?