delete from tablename a where a.rowid>(select min(rowid) from tablenam

Delete duplicate records in the emp table.

Question Posted / smriti

Answer Posted / smriti

delete from tablename a where a.rowid>(select min(rowid)
from tablename b where a.columnname=b.columnname)

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you remove duplicates without using distinct in sql?

1016

Explain ttitle and btitle.

1161

what is msql? : Sql dba

1043

what are all the different normalizations? : Sql dba

1112

How does a covering index work?

1008

Does google use sql?

1003

How do you delete a table?

1121

What is compute?

1146

explain access control lists. : Sql dba

1045

what is the functionality of the function htmlentities? : Sql dba

1004

What are the types of views in sql?

1136

What is sql prepared statement?

1032

What is nosql vs sql?

1223

what are all types of user defined functions? : Sql dba

1082

describe transaction-safe table types in mysql : sql dba

1050