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

How does a trigger work?

990

what is heap table? : Sql dba

1049

What is graph sql?

938

How do I partition in sql?

905

What is bitemporal narrowing?

1232

What are the steps for performance tuning.

1272

What is the use of sqldataadapter?

911

what is the use of double ampersand (&&) in sql queries?

1117

is mysql query is case sensitive? : Sql dba

1031

What is the difference between sql and isql*plus?

1008

Is there any restriction on the use of union in embedded sql?

1103

How can you load microsoft excel data into oracle? : aql loader

1130

What does closing a cursor do?

1247

what is the syntax for using sql_variant_property? : Transact sql

990

Define overloaded procedure?

1016