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 the difference between cross join and natural join?

1022

what is uncommittable transactions? : Transact sql

996

List the different type of joins?

1061

What are sql objects?

1081

Define SQL and state the differences between SQL and other conventional programming Languages?

1217

Explian rowid, rownum?

1012

What is the life of an sql statement?

1024

When do we use triggers?

1081

What are the uses of merge?

1167

Is sql similar to python?

976

what's the difference between a primary key and a unique key? : Sql dba

1050

Does truncate need commit?

948

Differentiate between % rowtype and type record.

1305

What are pl sql procedures?

1026

How many commands are in sql?

1072