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 ttitle and btitle?

1018

What is the difference between local and global temporary table?

1002

how to rename an existing table in mysql? : Sql dba

1014

Is and as keyword in pl sql?

912

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1005

What is the use of procedures?

930

What are the types of triggers in sql?

1028

What is difference between nchar and nvarchar?

968

What is benefit of creating memory optimized table?

918

Can pl sql procedure have a return statement?

967

what are the advantages of sql ? : Sql dba

1006

What are the differences between implicit and explicit cursors?

1016

What is a constraint? Tell me about its various levels.

1094

what is the difference between sql and t-sql? : Transact sql

1052

What is difference sql and mysql?

947