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 break?

1183

What is sql lookup?

906

How many parts of a pl sql block are optional?

1101

What is the reports view in oracle sql developer?

958

how to convert character strings to numeric values? : Sql dba

1080

Are left and right joins the same?

1055

Why is sql*loader direct path so fast?

1091

What is sql deadlock?

1113

Explain what is rdbms?

1018

What is a pl/sql block?

1199

What are inbuilt functions in sql?

1028

what is the difference between join and union? : Sql dba

1089

What are the rules to be applied to nulls whilst doing comparisons?

1311

Is mariadb nosql?

1030

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

1171