delete from emp x where rowid>(select min(rowid) from emp where rmpno=x

Delete duplicate records in the emp table.

Question Posted / amedela chandra sekhar

Answer Posted / amedela chandra sekhar

delete from emp x where rowid>(select min(rowid) from emp
where rmpno=x.empno);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql and how does it work?

1085

What is the max nvarchar size?

896

Why we use joins in sql?

924

What is an invalid partition table?

958

What is serial sql?

915

What does plv msg allows you to do?

1074

Enlist the advantages of sql.

937

what is sp_pkeys? : Transact sql

1099

What is type and rowtype in pl sql?

963

What is self-join and what is the requirement of self-join?

1088

what are the advantages a stored procedure? : Sql dba

923

How to return an array from java to pl/sql?

1060

What is pl/sql language case sensitive?

1058

What is faster join or subquery?

958

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1113