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 to drop an existing schema in ms sql server?

1144

what is a check constraint?

1171

When we should use @@error?

1033

How do I start sql server 2017?

984

Why do you need a sql server?

1170

What is a hint?

1056

What structure can you implement for the database to speed up table reads?

1234

Explain powershell included in sql server 2008?

1114

What is the minimum recommended amount of ram for sql server 2012 enterprise?

976

Explain transaction server distributed transaction?

1037

can you instantiate a com object by using t-sql? : Sql server database administration

1041

Do you know what are the steps to process a single select statement?

1018

Does a full backup include transaction log?

1047

Explain rdbms?

1076

What are the basic functions for master, msdb, model, tempdb and resource databases?

1033