Skip to content

SQL101-Homework Assignment #4

2006 March 17
tags:
by Shannon Lowder

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.

No comments yet

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS