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 primary key?

876

What is a recursive stored procedure?

1095

Is full outer join same as cross join?

912

Can we use having without group by in sql?

927

What is mdf ldf and ndf?

931

What is a heap in sql?

991

What is null in pl/sql?

1022

Can we use update in sql function?

1006

Why stored procedures are faster than query?

968

How to use transactions efficiently : transact sql

990

What is lexical units in pl sql?

1052

Can you skip header records while loading? : aql loader

972

What is the sql query to display the current date?

990

What is varchar example?

973

What are the built in functions of sql?

981