Skip to content

shannonlowder.com

Menu
  • About
  • Biml Interrogator Demo
  • Latest Posts
Menu

SQL101-Homework Assignment #4

Posted on March 17, 2006February 16, 2011 by slowder

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 Cancel reply

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

  • Career Development
  • Data Engineering
  • Data Science
  • Infrastructure
  • Microsoft SQL
  • Modern Data Estate
  • Personal
  • Random Technology
© 2023 shannonlowder.com | Powered by Minimalist Blog WordPress Theme