Delete from table t1 where t1.rowid>(select from table t2

Delete duplicate records in the emp table.

Question Posted / srinivas ganamur

Answer Posted / srinivas ganamur

Delete from table t1
where t1.rowid>(select from table t2
from table t2
where t1.col_name=t2.col_name);

Srinivas Ganamur
Bangalore

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is sp_helptext?

1061

Is join and inner join the same?

1000

What is the purpose of a secondary key?

963

How do you bind variables in pl sql?

1092

Can we use ddl commands in pl sql?

1159

Explain dml and ddl?

986

Is sql easier than java?

1004

What are the different types of triggers?

1130

What is secondary key?

932

What is clause in sql?

1108

how to enter characters as hex numbers? : Sql dba

1034

What is sql query limit?

975

What is pl sql package?

1029

Does truncate need commit?

940

What is scope and visibility in PL/SQL?

1196