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

What is your daily office routine?

2215

Is oracle and sql same?

953

What is tuple in sql?

1004

Is sql port 1433 encrypted?

968

When you have to use a default "rollback to" savepoint of plvlog?

1123

Can we use joins in subquery?

1085

What is a constraint? Tell me about its various levels.

1081

How do you know if a relationship is 2nf?

877

Can we use ddl statements in stored procedure sql server?

964

What is the usage of nvl function?

981

How can triggers be used for the table auditing?

1008

what are the 'mysql' command line arguments? : Sql dba

1087

Can we write ddl statements in functions?

1050

How do sql databases work?

943

What is sql entity?

1029