Question

How can we delete Duplicate row in table?

Answer 1

Hey guys

Let see what is your answer

To remove duplicate rows of data, use the following statement: DELETE FROM my_table WHERE rowid NOT IN ( SELECT MAX(ROWID) FROM my_table GROUP BY colA,colB,colC ); In the GROUP BY clause, enumerate all of your columns in your table, or the columns you think should be the primary key columns.