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 is the difference between openrowset and openquery?

1181

What is standby servers? Explain types of standby servers.

1067

How can I check that whether automatic statistic update is enabled or not?

1104

What are the kinds of subquery?

1089

do you know how to configure db2 side of the application? : Sql server database administration

1110

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

1485

How efficient you are in oracle and SQL server?

1241

What is sql or structured query language?

1208

What are different types of constraints?

985

List out the different types of locks available in sql server?

1041

Can sql servers link to other servers like oracle?

902

Can you index views?

951

Is it possible to have clustered index on separate drive from original table location?

1031

What are the source of constraints?

998

Can we shrink data file in sql server?

1114