delete tblname where columname in (select columnname FROM tblname GRO

how to delete duplicate rows from table in sql server

Question Posted / suresh s

Answer Posted / suresh s

delete tblname where columname in (select columnname
FROM tblname GROUP BY columnname having count(columnname)
>=2)

Is This Answer Correct ?

25 Yes

30 No

Please Help Members By Posting Answers For Below Questions

How do you debug a procedure in sql server?

890

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

850

How do I find sql server instance name?

915

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2027

Explain the different types of backups available in sql server? : sql server database administration

863

What are sql servers used for?

980

Explain external key management in sql server 2008

847

What does truncate do?

885

What are the differences between local and global temporary tables?

1013

Explain the cursor lock types?

982

What is a print index?

841

How to create an index on a view?

987

What does the update command do?

1051

What is function of CUBE ?

970

What is a view and what are its advantages?

1053