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

What are the types of variables use in pl sql?

964

how to start mysql server? : Sql dba

1141

What is the difference between a subquery and a join?

1009

What is a native sql query?

969

what is myisam? : Sql dba

999

what is an extent ? : Sql dba

1015

Is grant a ddl statement?

849

Is not null in sql?

922

What is the difference between rename and alias?

1266

What is rtm in testing?

1037

how to increment dates by 1 in mysql? : Sql dba

924

What is data types in sql?

946

How does join work in sql?

956

Does google use sql?

911

What is the difference between numeric and autonumber?

938