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

Write a query to display the current date in sql?

737

What is parameter substitution in sql?

752

Explain what is table in a database?

781

What is difference between mysql and postgresql?

703

What is having clause in sql?

714

Explain locks? : Transact sql

738

Is json a nosql?

723

What is the purpose of cursors in pl/sql?

798

What problem one might face while writing log information to a data-base table in pl/sql?

760

What is oracle sql developer?

787

Explain exception handling in pl/sql?

723

What does select top 1 do in sql?

725

What is memory optimized table?

761

Is sql port 1433 encrypted?

776

how are mysql timestamps seen to a user? : Sql dba

771