Write an SQL statement to delete all rows of pets of PetType Cat in the PET_3 ta

Question

Write an SQL statement to delete all rows of pets of PetType Cat in the PET_3 table. NOTE, do not use Anteater, as in the book. (Try it first without a WHERE clause.)

Check to make sure you used the correct table name

PetID PetName PetType PetBreed PetDOB PetWeight OwnerID 1 King Dog Std. Poodle 2009-02-27 00:00:00 25.5 1 2 Teddy Cat Cashmere 2010-02-01 00:00:00 10.5 2 3 Fido Dog Std. Poodle 2008-07-17 00:00:00 28.5 1 4 AJ Dog Collie Mix 2009-05-05 00:00:00 20.0 3 5 Cedro Cat Unknown 2007-06-06 00:00:00 9.5 2 6 Wooley Cat Unknown 9.5 2 7 Buster Dog Border Collie 2006-12-11 00:00:00 25.0 4

Explanation / Answer

DELETE FROM PET_3 WHERE PetType='Cat'

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.