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 database transaction? : Sql dba

1105

What are the datatypes available in pl/sql ?

1042

What is sql and how does it work?

1086

What kind of join is join?

903

What is sql prepared statement?

936

What is the usage of nvl function?

981

How insert into statements in sql?

1007

What are different types of sql?

1098

What is sql keyword?

943

What is a dirty read sql?

1032

Why partition by is used in sql?

969

What are the different types of functions in sql?

995

What do you mean by rowid?

914

What is a schema? How is it useful in sql servers?

1041

How many indexes can be created on a table in sql?

984