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.

Leave a Reply

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