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

How many types of stored procedures are there in sql server?

1015

How to create and drop temp table in sql server?

1051

What are different types of raid levels?

1168

What is the difference RDBMS and Graph Database?

1047

What are the properties of the transactions?

1119

What is blocking and how would you troubleshoot it? : sql server database administration

1043

What is the full form of dql?

984

What is store procedure? How do they work? When do you use?

942

What is the dbcc command and why is it used?

1052

What is resource governor in sql server?

995

Where are stored procedures in sql server?

1065

How can I check if a view exists in a sql server database?

1038

What is stored in the mssqlsystemresource database? : sql server database administration

1030

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1029