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 different types of triggers?

1116

What are the types of join in sql?

1078

Why are aggregate functions called so?

932

Write a unique difference between a function and a stored procedure.

976

what is a tablespace? : Sql dba

1037

Can we connect to postgresql using sql developer?

982

what is a stored procedure? : Sql dba

1108

Compare sql & pl/sql

1104

What is the difference between database trigger and stored procedure?

1058

What is a unique constraint?

1060

Explain autonomous transaction.

1148

Will truncate release space?

928

what is the difference between char_length and length? : Sql dba

1027

Are stored procedures compiled?

899

what are all types of user defined functions? : Sql dba

1029