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

what is a view? : Sql dba

1070

What are the constraints available in sql?

1037

What are the types of dbms?

964

What is the difference between between and in condition operators?

997

What are the possible values that can be stored in a boolean data field?

992

What is the purpose of the partition table?

1041

Write a query to find the names of users that begin with "um" in sql?

982

how to rename an existing table in mysql? : Sql dba

1053

How do I count records in sql?

984

What is sql*loader?

1166

What is the difference between row level and statement level trigger?

1012

What are the datatypes available in pl/sql ?

1093

Is sql low level language?

1009

Does varchar need length?

983

What do you mean by dbms? What are its different types?

1009