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

What is .net mobile lists. : Microsoft dot net mobile

952

where should I put this information then?

978

What are the main Tools to develop .Net Application?

965

Explain how does .net mobile work? : Microsoft dot net mobile

866

Are there any third party logging components available?

952

Explain how cache is used? : Dot net architecture

1081

How can I write my own .NET host?

1015

Explain write back and write through caches? : .NET Architecture

907

deference between display and visibility property of CSS

2279

Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?

1025

what is the method while we are using adapter and dataset ?

1861

Define a virtual memory? : Dot net architecture

919

how to change the title of my window?

1892

What do you know about machine.config file ?

954

Define the mesi? : Dot net architecture

940