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 are the sql aggregate functions?

603

How can we make an if statement within a select statement?

539

How to pronounce postgresql?

578

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

535

Can you do multiple joins in sql?

543

How do I restart sql?

524

What is trigger with example?

562

Explain select statements in sql?

584

Explain what is a field in a database and record in a database?

604

Which command is used to delete a package?

577

how would you get the current date in mysql? : Sql dba

537

How do you explain an index?

786

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

498

Does google use sql?

509

what is an index? : Sql dba

520