DELETE FROM table_name a WHERE ROWID >(SELECT min(ROWID)

How To delete duplicate record from a particular table?

Question Posted / manoj

Answer Posted / manoj

DELETE FROM table_name a
WHERE ROWID >(SELECT min(ROWID)
FROM table_name b
WHERE a.col_1=b.col_1 )

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to find out what is the default collation in a database?

1111

What are sql azure firewall rules?

106

What is difference between clustered and non clustered index?

980

How can we use ConnectorJ JDBC Driver with MS SQL?

993

What are joins in sql and what are the different types of joins?

1004

What are the general features of sql server management studio? : sql server management studio

1071

Difference between primary key and clustered index?

998

What kind of problems occurs if we do not implement proper locking strategy?

1395

How to modify an existing stored procedure in ms sql server?

1075

How and why use sql server?

997

How to optimize stored procedures in sql server?

1176

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1061

How to count rows with the count(*) function in ms sql server?

1007

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

932

What are the types of database recovery models?

1110