example delete from emp where deptno in (select deptno from dept where

write a query to delete similar records in different tables
with same structure

Question Posted / umadevi

Answer Posted / umadevi

example

delete from emp where deptno in (select deptno from dept
where emp.deptno=dept.deptno);

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Enlist the characteristics of pl/sql?

1809

What is sap sql anywhere?

1091

How do you write a subquery?

1035

What are synonyms in sql?

976

What is cursor in pl sql with examples?

1041

What is rtm in testing?

1124

What are % type and % rowtype?

1037

What is sql performance tuning?

929

What is varchar used for?

1087

What is a full join?

997

What is the difference between microsoft access and sql?

1035

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2172

What is the purpose of primary key?

1033

How to write a query to show the details of a student from students table whose

1004

What are the various levels of constraints?

1127