write a query to delete similar records in different tables with same structure

write a query to delete similar records in different tables
with same structure

Question Posted / pk

4 Answers
7949 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query to delete similar records in different tables with same structure..

Answer / vinoth kumar

DELETE FROM table1 WHERE
(col1,col2,..) IN (SELECT col1,col2,.. FROM table2 where
condition)

Is This Answer Correct ?

6 Yes

0 No

write a query to delete similar records in different tables with same structure..

Answer / radha sri seshu.kolla

while creating table and giving foreign key constraint give
the key word 'on delete cascade'.automatically when the
record in the master table is delated the relaeted record
in the detail table will also be deleted.

Is This Answer Correct ?

3 Yes

3 No

write a query to delete similar records in different tables with same structure..

Answer / 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

write a query to delete similar records in different tables with same structure..

Answer / senthil

This done by Co-related sub-query:- based upon ROWID
uniqness this deletes the duplicate rows.

Delete from emp x where ROWID != (Select MIN(ROWID) from
emp y where y.empno = x.empno);

Is This Answer Correct ?

2 Yes

4 No

Post New Answer