DELETE FROM table1 WHERE (col1,col2,..) IN (SELECT col1,col2,.. FROM tabl

write a query to delete similar records in different tables
with same structure

Question Posted / vinoth kumar

Answer Posted / vinoth kumar

DELETE FROM table1 WHERE
(col1,col2,..) IN (SELECT col1,col2,.. FROM table2 where
condition)

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is data manipulation language? : Sql dba

1021

What is oracle pl sql developer?

984

Is sql developer case sensitive?

1000

What is dba in sql? : SQL DBA

1044

How many aggregate functions are available there in sql?

984

What is sql profiling in oracle?

1065

How to get unique records from a table?

973

Is sqlexception checked or unchecked?

968

Can we use distinct and group by together?

1057

what are the differences between binary and varbinary? : Sql dba

1044

What is your daily office routine?

2272

Does mysql_real_escape_string prevent sql injection?

950

What is the difference between instead of trigger and after trigger?

1011

What is not in sql?

950

How does rowid help in running a query faster?

1416