SET ROWCOUNT 1 DELETE FROM tbl_name WHERE field_name= 'field

How to delete the duplicate records in a table using sql
server

Question Posted / mohamed idhris

Answer Posted / mohamed idhris

SET ROWCOUNT 1

DELETE FROM tbl_name WHERE field_name= 'field_value'

SET ROWCOUNT 0

the above query will delete the duplicate row

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Define domestic architecture artifacts? : Dot net architecture

865

Define dma? : Dot net architecture

925

Explain .net mobile events? : Microsoft dot net mobile

911

Can you Explain element .net mobile with example? : Microsoft dot net mobile

902

How do you handle this COM components developed in other programming languages in .NET?

1011

When do I need to use gc.keepalive?

1018

Difference between throw exception and rethrowing ?

2051

Is .net easier than java?

879

What is a clickonce application?

883

Explain Singleton design pattern in .net

944

server.transfer limitation ?

2178

Explain write back and write through caches? : Dot net architecture

976

HttpHendler and HttpModules

2112

How does an appdomain get created?

905

What is gui programming? : .NET Architecture

879