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

What is asqueryable?

533

what is heap table? : Sql dba

610

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

521

What is oracle pl sql developer?

532

What is oracle sql called?

506

What are the most important ddl statements in sql?

577

Can a procedure in a package be overloaded?

549

How do you update a sql procedure?

527

What is the difference between pl and sql?

545

how tsql statements can be written and submitted to the database engine? : Transact sql

536

What is an index in sql with example?

519

What are different types of queries in sql?

525

Who is the owner of mysql database?

553

What is sql performance tuning?

497

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

642