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

Can we insert data into view?

898

What is having clause in sql?

963

How many commands are in sql?

1066

Is sql difficult?

1150

When you have to use a default "rollback to" savepoint of plvlog?

1187

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1096

What is graph sql?

986

how to rename an existing column in a table? : Sql dba

1016

What is data control language?

985

What is rename in sql?

971

Define the select into statement.

1048

What is the use of sql trace?

950

Which command is used to delete a package?

1164

What is an example of translating a date into julian format?

1115

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1105