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

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1122

how to check server status with 'mysqladmin'? : Sql dba

1065

What is schema in sql example?

1169

What does select top 1 do in sql?

1083

What is sql mysql pl sql oracle?

1063

What are the types of keys?

987

What is difference between inner join and self join?

1075

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1050

how to select unique records from a table? : Sql dba

1100

What is meant by user defined function?

1034

Is not equal in sql?

1005

Does sql*plus have a pl/sql engine?

1062

Can a table contain multiple primary key’s?

1090

What are the possible values that can be stored in a boolean data field?

992

What is the primary key?

943