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

What is the default port for SQL Server over a firewall?

1085

How do we know if any query is retrieving a large amount of data or very little data?

969

How do I edit a procedure in sql server?

948

Which is better statement or preparedstatement?

920

List out the differences between the clustered index and non-clustered index in sql server?

997

Can I work with several databases simultaneously? : sql server management studio

981

What are trace files?

946

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1502

How to get a list of columns in a view using the "sp_help" stored procedure?

1030

Describe and explain about SQL native client?

1100

What are ddl (data definition language) statements for tables in ms sql server?

1095

What do you understand by check constraint in sql server?

939

Is the primary key column of a table an index in ms sql server?

958

How to backup encryption key ?

182

What is an entity-relationship diagram (erd)?

1202