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 to use boolean type in select statement?

1051

Is progress software supports to ( pl/sql )?

1022

Explain 3 basic parts of a trigger.

1299

Which software is used for pl sql programming?

970

What is faster join or subquery?

998

How do you update f as m and m as f from the below table testtable?

1834

what is offset-fetch filter in tsql? : Transact sql

931

What does select top 1 do in sql?

1077

What is a heap in sql?

1047

what is a control file ? : Sql dba

1019

What are operators available in sql?

1024

what is log shipping? : Sql dba

1093

what are enums used for in mysql? : Sql dba

1157

What is the use of sql trace?

937

What is the basic structure of an sql?

1079