DELETE FROM tablename A WHERE ROWID>(SELECT MIN(ROWID) FROM tablename

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 / samir kumar sahoo.

Answer Posted / samir kumar sahoo.

DELETE FROM tablename A WHERE ROWID>(SELECT MIN(ROWID) FROM
tablename B WHERE A.key_values=B.key_values);

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is not null constraint? : Sql dba

1073

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1026

What is full join?

1015

What are database links used for?

1093

What is the difference between partitioning and sharding?

1046

Is primary key clustered index?

990

How does join work in sql?

1048

Why is theta join required?

1185

Which is better stored procedure or query?

1013

Difference between table function and pipelined function?

1076

How do you modify a trigger?

977

What is the difference between having clause and where clause?

1108

Explain select statements in sql?

1100

What is the use of pl/sql table?

1100

how to create a new view in mysql? : Sql dba

982