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

How much ram can sql express use?

996

Which operator is used in query for pattern matching?

1096

Is there a 64 bit version of ssms?

966

what is a composite key ? : Sql dba

1069

What is varchar example?

1040

what's the difference between a primary key and a unique key? : Sql dba

1060

What is materialized view in sql?

927

Why use triggers in sql?

963

What is delimiter in pl sql?

1065

What is the meaning of disabling a trigger?

1188

What is the maximum size of sqlite database?

1117

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1176

What is a join?

1077

What is the purpose of normalization?

1053

What is the starting oracle error number?

1066