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 undefined value and null value? : Sql dba

822

What is compute?

780

how to enter binary numbers in sql statements? : Sql dba

753

How to return an array from java to pl/sql?

848

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

903

What are field types?

754

Is sql better than excel?

776

Why primary key is required?

754

Can we join two tables without common column?

743

Which operator is used in query for pattern matching?

873

How do I clear the screen in sql plus?

792

What is numeric function sql?

766

Name the operator which is used in the query for pattern matching?

723

What is break?

916

What is sql indexing?

786