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 do I run a sql trace?

908

What is $$ in sql?

943

Is sqlite free?

908

Is primary key is clustered index?

942

what are the join types in tsql? : Transact sql

983

What is record data type?

861

What is ttitle and btitle?

1007

What are pl/sql cursors?

991

What is auto increment?

936

what is offset-fetch filter in tsql? : Transact sql

893

How is debugging done?

921

What are the different dcl commands in sql?

1069

when MSQL8.0 is in market

2016

What is database sql?

988

Which is faster union or join?

903