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

Why is pl sql used?

976

How many developers work on postgresql?

969

What is view? Can we update view

1424

What is basic structure of pl sql?

1065

what are different types of keys in sql?

1139

How to process query result in pl/sql?

1117

How does one load ebcdic data? : aql loader

1159

what is index? : Sql dba

996

Why do we use view in sql?

944

Write a query to display the current date in sql?

1016

What are the most important ddl statements in sql?

1100

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

987

Can we insert data in view?

953

what are tables and fields? : Sql dba

1037

Why are cursors used?

1114