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

Explain the steps to create and execute a user-defined function in the sql server?

967

How to replace the Query Result 'Null Value' with a text ?

1043

What factors you will consider calculating the storage requirement for that view?

949

What is a deadlock and what is a live lock?

1003

Differentiate between SQL and ORACLE joins and write their syntax.

1034

How to provide login information for a new odbc dsn?

1052

What are the Advantages of using CTE in sql server?

1119

Explain what are commit and rollback in sql?

931

Define right outer join?

980

What is the need for indexing?

951

How fixed length strings are truncated and padded?

980

Do you know the cursor optimization tips?

985

How many servers can we create in a single subscription?

162

What do you mean by recursive stored procedure?

950

How to create a user to access a database in ms sql server using "create user" statements?

951