delete from table_name where rowid not in(select min(rowid) from table

write a query to delete similar records in same table

Question Posted / nirmalendu

Answer Posted / nirmalendu

delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name);

** column_name which having duplicate record

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is query cache in mysql? : Sql dba

1026

What is the use of primary key?

1005

What is the difference between database trigger and stored procedure?

1066

how to include numeric values in sql statements? : Sql dba

1097

What is an implicit commit?

1048

what is column? : Sql dba

1000

How to convert comma separated string to array in pl/sql?

1173

What are analytical functions in sql?

1023

How many sql core licenses do I need?

944

Explian rowid, rownum? What are the psoducolumns we have?

997

when is the use of update_statistics command? : Sql dba

1041

what are the different type of sql's statements ? : Sql dba

921

What is blind sql injection?

1063

What are hotfixes and patches?

941

What is varchar sql?

1129