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

What does select 1 mean?

884

Explain few examples of stored procedure over triggers?

961

What are the new security features added in sql server 2012? : sql server security

948

Define msdb database?

972

Which are the new data types introduced in sql server 2008?

843

What is the difference between commit and rollback?

876

Do you know sql server 2008 backup compression?

919

How would you use user_constraints table in DB?

939

What is the difference RDBMS and Graph Database?

1004

How do you Implement SSIS Packages in your Project?

1870

What number aggregate functions are accessible there in sql?

1007

What are the results of running this script?

861

What is the difference between varchar and nvarchar?

897

How does normalization work?

865

What is a matrix in ssrs?

135