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

Why does sql need a server?

1028

How do I truncate a sql log file?

1061

What is an example of translating a date into julian format?

1107

Is vs as in pl sql?

978

What is the difference between a database and a relational database?

1094

Difference between truncate, delete and drop commands?

1076

What is the plv (pl/vision) package offers?

1039

What is orm in sql?

1037

What are the commands used in sql?

1059

What is the difference between sql and t sql?

1024

how do you login to mysql using unix shell? : Sql dba

1072

Explian rowid, rownum?

1001

What is sql lookup?

910

what are the different tables present in mysql? : Sql dba

972

Can we use rowid as primary key?

979