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 osql utility?

941

What are the features of Embedded SQL

1115

What is a result set object returned by odbc_exec()?

1003

What are two difference between sql azure and azure tables?

159

What is stored procedures?

1004

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

968

Can group functions be used in the order by clause in ms sql server?

997

How many replicas are maintained for each SQL Azure database?

142

Mention the differences between local and global temporary tables.

1005

What is a scheduled job or what is a scheduled task?

944

How to drop an existing table with "drop table" statements in ms sql server?

1067

What are the difference between “where” and “having” clause in sql server?

1051

What is bit data type? What's the information that can be stored inside a bit column?

905

Does full backup break log chain?

947

How to change the data type of an existing column with "alter table" statements in ms sql server?

971