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

Can I create my own permission set?

1109

What is .net mobile input validation. : Microsoft dot net mobile

978

how to make and display a form without title bar?

1992

What other than biginteger has been introduced in system.numerics namespace?

1006

What is biginteger and when would you use that?

1003

State the different levels of exceptional safety?

1050

What is application frame host?

1132

How cache is used? : Dot net architecture

1052

Explain about microsoft visual studio?

1028

What are different types that a variable can be defined and their scopes ?

1101

What is the difference between .net mobile pages and ordinary .net web page? : Microsoft dot net mobile

1000

What is .net mobile lists. Explain with an example? : Microsoft dot net mobile

943

What does the term "green architecture" mean? : Dot net architecture

952

5. Wcf- Session Managment

2029

What is MS chart control in visual studio?

1291