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 tables in sql?

542

what is query cache in mysql? : Sql dba

571

What is memory optimized table?

569

What is primary key in db?

513

What is the maximum number of columns in sql table?

543

What is where clause in sql?

528

Why is sql better than hql?

500

Mention what plvcmt and plvrb does in pl/sql?

626

What is set transaction?

575

Can I learn sql in a week?

545

What is data profiling in sql?

509

What is equi join in sql?

604

Why truncate is used in sql?

526

Can we join two tables without common column?

507

What is type and rowtype in pl sql?

531