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

Explain the difference in execution of triggers and stored procedures?

1022

What is linq to sql?

1132

What is sql and explain its components?

1057

What is nosql example?

1031

What is trigger types of trigger?

1066

How to rename a table?

1012

What is query optimization in sql?

983

How do you copy a table in sql?

1066

how to get a list of indexes of an existing table? : Sql dba

955

what are aggregate and scalar functions? : Sql dba

1055

What is sql in java?

1076

How do I access sql anywhere database?

969

What is pls_integer in pl sql?

1103

What is pragma in sql?

1071

What is bitemporal narrowing?

1305