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

What are the advantages of pl sql over sql?

546

What is meaning of <> in sql?

583

what is 'mysqld'? : Sql dba

540

What are the different types of tables in sql?

483

What does truncate mean in sql?

534

What is sp_helptext?

590

Do stored procedures prevent sql injection?

544

How to convert comma separated string to array in pl/sql?

596

What is Difference Between Unique and Primary Key Constraints?

604

Are stored procedures faster than dynamic sql?

528

Define commit, rollback and savepoint?

571

How to select 10 records from a table?

645

What is query optimization in sql?

548

Why functions are used in sql?

513

what are the different index configurations a table can have? : Sql dba

568