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

When I run the sql server 2000 setup, it just hangs. What do I do?

1020

What is SQL Azure Federations?

112

Where do you find the default Index fill factor and how to change it?

1016

What are indexes in sql?

1177

What is the difference between for xml raw and for xml auto?

976

What is open database communication (odbc)?

1005

What are indexers?

1036

Do you know how to make remote connection in database?

904

What are the different authentication modes in sql server?

1052

How to create a trigger for insert only?

982

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

116

What is the function of sql server agent windows service?

1030

What is the purpose of sql profiler in sql server?

962

Explain what role entity and relationship play in an ER diagram.

1018

Scalability, Availability, Integration with internet, etc.)?

2823