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

How does rowid help in running a query faster?

1416

What is sql and explain its components?

1067

How do you respond to dementia behavior?

971

What packages(if any) has oracle provided for use by developers?

5811

What are %type and %rowtype for?

1052

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

953

when is the use of update_statistics command? : Sql dba

1049

what is a database? : Sql dba

1173

Can you inner join the same table?

992

what is bcp? When is it used?

1112

What are aggregate and scalar functions?

1025

What is rank function in sql?

1029

What is the use of sqlerrd 3?

944

What are stored procedures in mysql?

1019

how to fetch alternate records from a table? : Sql dba

1112