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 union, minus and interact commands? : Sql dba

1257

What is sql trigger example?

1115

What are stuff and replace function?

1143

How do you update sql?

1039

Does oracle roll back the transaction on an error?

1070

What does := mean in pl sql?

1091

Can you rollback after commit?

1054

what are myisam tables? : Sql dba

1079

What do you know by pl/sql cursors?

1170

What is the order of sql select?

1089

Is null operator in sql?

1094

What is the use of double ampersand (&&) in sql queries? Give an example

1190

What are the various levels of constraints?

1170

What are sql indexes?

1048

What is acid property in a database?

1087