Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 13944 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ram
Guys, Please see the question again. It is related to
deleting different tables. I guess, the question is
intented to get the answer - ON DELETE CASCADE. We give
foreign constraints on tables and when the parent record is
deleted, the child records are automatically deleted when
you give command as ON DELETE CASCADE
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are synonyms in sql?
what are the drivers in mysql? : Sql dba
What are the triggers associated with image items?
What is trigger explain with example?
What are all the different types of indexes?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What are joins in sql?
How do I view a procedure in sql?
what is a cursor? : Sql dba
How many sql are there?
What is rollback?
What is package in pl sql with an examples?
What is primary key secondary key alternate key candidate key?
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
How are sql commands classified?
