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 is a composite primary key ? : Sql dba

1026

Can we use view in stored procedure?

888

How do I start pl sql?

932

What is the difference between delete and truncate commands?

1020

How do I save a sql query?

1001

what is uncommittable transactions? : Transact sql

987

how to present a past time in hours, minutes and seconds? : Sql dba

991

Can you sum a count in sql?

985

What can sql server reporting services do?

1096

How do I copy a table in sql?

965

Explain select statements in sql?

1043

how do you tune the slow running queries in oracle db , explain the methodology

2582

What is t-sql? : Transact sql

969

What are the advantages of normalization?

1068

Can you have a foreign key without a primary key?

938