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

What is a full join sql?

1057

what are the advantages and disadvantages of views in a database? : Sql dba

1043

What is auto increment in sql?

1122

what is a unique key ? : Sql dba

1092

what are the advantages of using stored procedures? : Sql dba

1105

Can we create a trigger on view?

896

Can a foreign key be a duplicate?

911

Can we insert in sql function?

1089

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

1044

Is sql a case sensitive language?

947

How do you change a value in sql?

1019

Define tables and fields in a database

1131

What is data modelling in sql?

1020

what are rollup and cube in t-sql? : Transact sql

1100

Explain cursor types?

1030