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

How does cross join work in sql?

527

Is oracle sql free?

532

Can a key be both primary and foreign?

502

What is a null value?

653

Why do we need cursors in pl sql?

512

Are dml statements autocommit?

543

what are all types of user defined functions? : Sql dba

536

How can I delete duplicate rows?

556

What is sql basics?

569

How many types of normalization are there?

483

what is self join and what is the requirement of self join? : Sql dba

673

What is difference between left and right outer join?

509

Is sql developer case sensitive?

510

What are different sql data types?

500

What does the hierarchical profiler does?

560