How to write query to Delete the records in child table and corresponding rec

How to write query to Delete the records in child table
and corresponding records in parent table

Question Posted / tester

Answers were Sorted based on User's Feedback

How to write query to Delete the records in child table and corresponding records in parent table..

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

More SQL Server Interview Questions

How do you find the error, how can you know the number of rows effected by last SQL statement?

What is snapshot replication?

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

What is the cartesian product of table?

What is the maximum length of an alert name?

Explain what are the different index configurations a table can have?

How does stuff differ from the replace function?

What is a coalesce function?

Explain how dts is used to extract, transform and consolidate data?

How do I partition a table in sql server?

What is normalization and its types?

How to get the count of distinct records. Please give me the query?

For more SQL Server Interview Questions Click Here