delete from emp where emp_no in (select emp_no from emp2 where emp.emp

write a query to delete similar records in particular
fields(columns) in different tables

Question Posted / madhu

Answer Posted / madhu

delete from emp where emp_no in
(select emp_no from emp2 where emp.emp_no=emp2.emp_no)

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How we can update the view?

1054

Define concurrency control. : Transact sql

1195

What are stuff and replace function?

1091

What is difference between stored procedure and trigger?

1178

How do I filter in sql profiler?

1003

What is gpt format?

947

What is the difference between row level and statement level trigger?

1031

Can primary key be changed?

913

What is Histogram?

1564

What is procedure and function in sql?

1003

What is time based sql injection?

965

Explain the savepoint statement.

1102

What are the possible values for the boolean data field?

970

what is transaction? : Sql dba

1013

What are the qualities of 2nf?

1045