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 a record in a database ? : Sql dba

1046

Is sqlexception checked or unchecked?

950

Is truncate ddl or dml?

976

Which sorts rows in sql?

1001

What is a behavioral trigger?

961

what is the difference between a local and a global temporary table? : Sql dba

1046

Define SQL and state the differences between SQL and other conventional programming Languages?

1197

What is exception? What are the types of exceptions?

1061

What type of database is cloud sql?

1084

Why do we need sharding?

978

Is sqlite free?

950

what is an extent ? : Sql dba

1073

what is “go” in t-sql? : Transact sql

1088

What is trigger in pl sql with examples?

1016

Is and as keyword in pl sql?

943