delete from emp where emp_no in (select emp_no from emp2 where emp.emp

write a query to delete similar records in particular
fields(columns) in different tables

Question Posted / madhu

Answer Posted / madhu

delete from emp where emp_no in
(select emp_no from emp2 where emp.emp_no=emp2.emp_no)

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain the components of sql?

593

explain commit and rollback in mysql : sql dba

549

How many sql statements are used?

570

How do I order by ascending in sql?

542

What is percent sign in sql?

722

What are the possible values that can be stored in a boolean data field?

517

What is the reports view in oracle sql developer?

545

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

531

what happens if null values are involved in expressions? : Sql dba

569

What does where 1/2 mean in sql?

540

Why sql query is slow?

583

what is myisam? : Sql dba

578

How do you run a query?

589

what is a view? : Sql dba

638

what is meant by nl2br()? : Sql dba

567