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

How to select 10 records from a table?

1206

What is cte?

1019

Can we insert in sql function?

1142

List the ways to get the count of records in a table?

942

What is pragma in sql?

1125

In pl/sql, what is bulk binding, and when/how would it help performance?

1032

What are different types of tables in sql?

1049

What are the subsets of sql?

1194

What is difference between nchar and nvarchar?

1100

How do you modify a column in sql?

1047

What is the purpose of cursors in pl/sql?

1200

How to change sql*plus system settings?

1106

What is record variable?

1039

How many sql statements are used? Define them.

1081

Explain the uses of a database trigger?

1086