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

Can a foreign key be a duplicate?

858

How does sql*loader handles newline characters in a record? : aql loader

984

what are the limitations of identity column? : Transact sql

1041

How many types of triggers exist in pl/sql?

1008

How many triggers can be applied to a table?

992

What is an exception in PL/SQL? What are the two types of exceptions?

1187

What does joining a thread mean?

972

What is where clause in sql?

979

What is hibernate and its relation to sql?

1063

How do I edit a stored procedure?

944

Why use triggers in sql?

890

What does pl sql stand for?

1062

What do you think about pl/sql?

942

What are the possible values for the boolean data field?

897

What is ttitle and btitle?

1006