delete from table_name where rowid not in (select max (rowid) from table g

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / raghavendraprasad

Answer Posted / raghavendraprasad

delete from table_name where rowid not in (select max
(rowid) from table group by duplicate_values_field_name);

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Does sap use sql?

1034

What is rank function in sql?

1066

What are the different dcl commands in sql?

1223

What is output spooling in sql*plus?

1082

What is pl sql collection?

1010

What are the types of dbms?

1018

What is cursor explain with example?

1024

What is partition in sql query?

1042

Can we use commit inside a trigger?

1140

What is a schema sql?

1213

Can we update views in sql?

985

What are the types of keys?

1060

Does pl sql work in mysql?

1031

What is exit statement?

1056

how can you see all indexes defined for a table? : Sql dba

1045