SQL101-Homework Assignment #4

Here are some more practice problems.  This time you’re going to practice using DELETE.

1. Write a DELETE query that would remove a record from person.contact by contactID, pick a contactID that does not exist in person.contact.

2. Write a DELETE query that would remove a record from person.contact by first and last name.

3. Write a DELETE query that would remove a record from example.person where they also exist in person.contact.

As always, if you have any questions, please let me know

UPDATE: Here are the answers.

By Shannon Lowder

Shannon Lowder is the Database Engineer you've been looking for! Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.

Leave a comment

Your email address will not be published. Required fields are marked *