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

Can you edit the .rdl code associated with a linked report?

166

What is the purpose of indexing?

1049

What is create command?

977

How many types of cursor type are there?

1098

How can I track the changes or identify the latest insert-update-delete from a table?

974

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

1008

What are the different types of Indexes available in SQL Server?

1013

Where to find ntwdblib.dll version 2000.80.194.0?

965

Explain filtered indexes benefits?

1009

Give a example to search fr a string in all stored procedure in sql server.

992

What do you understand by user-defined function in the sql server?

962

What is the difference between value type and reference type?

929

Difference between connected and disconnected database in .net with sql server?

1108

What is it’s similarity with sql server?

160

How to defragment indexes with alter index ... Reorganize?

1090