select * from dbo.duplicatetest set rowCount 1 delete from dbo.duplicatet

Write a query to delete duplicate records in SQL SERVER

Question Posted / ashish kumar

Answer Posted / ashish kumar

select * from dbo.duplicatetest
set rowCount 1
delete from dbo.duplicatetest where iD=1;
set rowCount 0

Is This Answer Correct ?

3 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What happens when converting big values to numeric data types?

1116

How to convert numeric expression data types by assignment operations?

1060

What do you mean by data integrity?

1060

What is a transaction and why is it important?

1080

Explain about unique identifier data type in sql server?

903

How to transfer data from a cursor to variables with a "fetch" statement?

1082

How to download and install microsoft .net framework version 2.0?

1131

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1036

What new data source types were added in ssrs 2014?

160

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1207

What is sub-query in sql server? Explain its properties.

1082

what do you understand by change data capture?

990

What is table join?

1108

What is difference between group by and having?

941

How to create a ddl trigger using "create trigger" statements?

1117