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

Tell me .net mobile emulators? : Microsoft dot net mobile

552

What are bindings?

555

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

546

Is .net easier than java?

519

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

495

What is .net mobile forms? : Microsoft dot net mobile

509

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

517

data types used in validation control

1748

How will you do windows authentication and what is the namespace?

540

can u give me real example of how web.config overrides the machine.config file?

1292

which is the institute in hyderabad for providing the live project industry training

2332

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

476

What is the application frame host?

522

Explain Intermediate Language?

601

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

578