Interested to Buy Any Domain ? << Click Here >> for more details...
How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 34988 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaishali
delete from child_table, parent_table where
child_table.parent_id=parent_table.parent_id
| Is This Answer Correct ? | 14 Yes | 26 No |
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How many nested transaction can possible in sql server?
Explain the disadvantages of cursors?
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
Can group by and orderby be used together?
Find top Nth employee from each department in terms of salary?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
How does clustered and non clustered index work?
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
What is the maximum rows in sql server table?
What is the difference between migration and upgradation in sql server?
What is a non equi join?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
