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 'mysqladmin' in mysql? : Sql dba

1073

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

1239

Is clustered index a primary key?

986

Can we delete column in sql?

1171

How many times can we commit in a loop?

1066

Why do you partition data?

1065

Explain the savepoint statement.

1135

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1047

What is the difference between rename and alias?

1387

Is sql procedural language?

1011

what is table? : Sql dba

1108

How do you go back in sql?

1027

Can there be 2 primary keys in a table?

1041

what are the difference between clustered and a non-clustered index? : Sql dba

1082

What is indexes?

1115