delete from emp where rowid not in(select min(rowid) from emp group by em

Delete duplicate records in the emp table.

Question Posted / 14-07-2007

Answer Posted / 14-07-2007

delete from emp where rowid not in(select min(rowid) from
emp group by empno;

Is This Answer Correct ?

13 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I count rows in sql?

1048

What is view explain with example?

996

How is debugging done?

1020

What is a call statement? Explain with an example.

1069

what are the drivers in mysql? : Sql dba

1059

What is a primary key sql?

1093

What are the advantages of pl sql?

1166

what is the difference between union and union all? : Sql dba

1068

Which join condition can be specified using on clause?

1012

what is meant by nl2br()? : Sql dba

1105

What will you get by the cursor attribute sql%found?

1009

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1008

What is dml with example?

1154

Why is there a need for sqlcode and sqlerrm variables?

1101

How would you pass hints to the sql processor?

1039