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 is a schema? How is it useful in sql servers?

586

What is natural join in sql?

530

how to use case expression? : Sql dba

544

What is procedure explain with program?

546

how would you enter characters as hex numbers? : Sql dba

508

How do I add a primary key to a table?

535

Explain the uses of control file.

606

What are schema-level triggers?

570

What are sql data types?

538

What are analytic functions in sql?

543

What is difference between stored procedure and trigger?

527

What is prepared statement in sql?

539

Define select, insert, create, delete, update, drop keywords

592

What is pl/sql table? Why is it used?

553

What is varray in pl sql?

559