Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

More SQL PLSQL Interview Questions

What are commit, rollback, and savepoint?

0 Answers  


what is data integrity? : Sql dba

0 Answers  


How delete a row in sql?

0 Answers  


What is the execution plan in sql?

0 Answers  


Explain how can you save or place your msg in a table?

0 Answers  


what is julian date in oracle

2 Answers  


Why is theta join required?

0 Answers  


How do I view a view in sql?

0 Answers  


What is dynamic query?

0 Answers  


What schema means?

0 Answers  


Explain the concept of normalization.

3 Answers  


what are the type of locks ? : Sql dba

0 Answers  


Categories