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 are the benefits of triggers?

1175

What is a unique key?

1060

how to write date and time literals? : Sql dba

968

Is sql database free?

983

How do I send sql query results to excel?

1072

Is ms sql traffic encrypted?

929

what are different types of collation sensitivity? : Sql dba

1074

What are sql constraints?

1180

Is sql free?

975

what are the drivers in mysql? : Sql dba

1027

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1137

How do I add a database to sql?

1131

What is the difference between cross join and natural join?

1029

How do you remove duplicate records from a table?

945

Why is sharding used?

1005