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 programs use sql?

982

Define sql delete statement.

989

What is a call statement? Explain with an example.

991

How do we use distinct statement? What is its use?

1013

Explain clause in sql?

1008

What is foreign key and example?

917

What is materialized view in sql?

909

What does trigger mean in psychology?

948

Is left join faster than inner join?

1106

Which function is used to return remainder in a division operator in sql?

1117

How will you distinguish a global variable with a local variable in pl/sql?

1132

Can we join same table in sql?

1000

Is record in oracle pl sql?

944

What is the most restrictive isolation level? : Transact sql

1069

What is trigger in pl sql?

980