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

Explain about metadata?

919

State and explain about microsoft.net?

932

How to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

930

Explain pipelining? : .NET Architecture

947

Can I create my own metadata attributes?

1026

What is the mesi? : Dot net architecture

1018

What are the main Tools to develop .Net Application?

946

How to prevent my .NET DLL to be decompiled?

1042

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

850

What are the types of application software?

952

What is the purpose of Accordian in jquery? Where it can be used?

2284

What are the new features of .net 2.0?

959

How do I prevent concurrent access to my data?

1026

Why the config file might not be writable

1122

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

889