delete from emp where rowid>any(select min(rowid) from emp a where a.

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / dinesh mohan upadhyay

Answer Posted / dinesh mohan upadhyay

delete from emp
where rowid>any(select min(rowid) from emp a where
a.col1=col1)

Is This Answer Correct ?

15 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How do you delete duplicates in sql query using rowid?

934

What is trigger explain with example?

1021

How do I make sql search faster?

988

What is database sql?

1038

Is it possible to read/write files to-and-from PL/SQL?

1095

Can 2 queries be executed simultaneously in a distributed database system?

1136

How can we store rows in PL/SQL using array?

1208

Explain locks? : Transact sql

993

What are inner and outer joins examples of both?

948

What is the difference between stored procedure and view?

1013

Why we use triggers in mysql?

986

What is clustered and nonclustered index in sql?

935

What is clustered index in sql?

1044

What is the difference between the implicit and explicit cursors?

1035

what is an extent ? : Sql dba

1080